Tag: DAX Measures

Calculate Percentage In Power BI In Hierarchical Form

Calculate Percentage In Power BI In Hierarchical Form - Enterprise DNA

You might encounter a requirement where you’ll need to display the ratio percentage of a particular level in your data against a parent level. Many might find this to be a tricky task as there is no straightforward function to achieve this result. In this tutorial, I am going to demonstrate how you can calculate

Continue reading

DAX Power BI Tutorial On Report Transparency

Developing Report Transparency Using DAX Formulas - Enterprise DNA

For this blog post, I will be moving on to the last part of my series on report transparency. The first part of this series talks about layout design, while the second part deals with navigation. I would like to move on to the next part of our series, which will be a DAX Power

Continue reading

Data Modeling Techniques To Organize DAX Measures

As you progress in Power BI, you will gradually be working with more DAX measures and calculations, and things can easily get cluttered. For today’s tutorial, I will share a few data modeling techniques on how to organize your DAX measures better for a more efficient workflow. You can watch the full video of this tutorial at

Continue reading

DAX Language Power BI Tutorial On Reverse TOPN

In this blog post, we are going to take a look at a question that was asked on the Enterprise DNA forum and use a DAX language Power BI technique to solve it. In case you want to follow along and download the files, just visit the Enterprise DNA forum and go to this link.

Continue reading

Power BI Development Techniques Using DAX Patterns | Enterprise DNA

For this blog, I’d like to give you an overview of how you can speed up your Power BI development. I always think about ways on how we, at the Enterprise DNA community, can empower ourselves and the Power BI community to develop more quickly inside Power BI. I’ve observed many areas of inefficiencies around

Continue reading