Tag: COUNTROWS Function

How To Use The COUNTROWS DAX Function In Virtual Tables

I want to dive deeply into how useful the COUNTROWS DAX function can be. You could be a newbie who hasn’t fully grasped how COUNTROWS works. You could also be a more experienced Power BI user but are unsure of how you can maximize the function. Through the examples I’ll be giving below, you’ll see

Continue reading

How To Compare Two Lists Of Calculated Data Virtually – An Advanced DAX Technique

How To Compare Two Lists Of Calculated Data Virtually - Advanced DAX Technique

When working with calculated data, comparing different data sets will sometimes be necessary. I’m going to show you how to do that by combining different table functions. The INTERSECT function is the best thing to use in cases like these. Some may also say that EXCEPT is just as useful in comparing calculated data. But

Continue reading

How Many Staff Do We Currently Have – Multiple Dates Logic In Power BI Using DAX

In this tutorial, you’ll learn how to work out the current staff population for multiple dates in Power BI using the COUNTROWS and FILTER function. This discussion is based on a question in the Enterprise DNA support forum. A Power BI user wanted to calculate the number of staff members that have been hired within

Continue reading

How to Maximize The Use of INTERSECT Function – Advanced DAX

The INTERSECT function in Power BI is an advanced table function and you need to understand it better so you can maximize the use of this advanced DAX. But to understand how it works, you need to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within

Continue reading

Group Customers Dynamically By Their Ranking w/RANKX In Power BI

As many of you know by now, I am huge on showcasing how you can apply Advanced DAX Formula to discover insights that historically have been difficult to find and also showcase easily. Well, this is another example of that and a great way to segment or group results rather than just showing results by

Continue reading