Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created the following DAX to get the count of all records in a dimension (Getting rid of NAs)
Possible odd DAX Behaviour of a DISTINCTCOUNT of a dimension key
Solved! Go to Solution.
Hi @DebbieE ,
This has to do with the context and the way the calculate works. The use of calculate with a filtering when applied make the same calculation has a filter all.
In your case when you take out the ID from the measure it will pick up all the values from the ID and then getting the 16 instead of 1 for each of the values.
Check the link about the CALCULATE and how it works.
Context is everything especcially when working with calculate, in this case you should substitute the ID by the SUBTERM and believe you will get the correct result.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @DebbieE ,
This has to do with the context and the way the calculate works. The use of calculate with a filtering when applied make the same calculation has a filter all.
In your case when you take out the ID from the measure it will pick up all the values from the ID and then getting the 16 instead of 1 for each of the values.
Check the link about the CALCULATE and how it works.
Context is everything especcially when working with calculate, in this case you should substitute the ID by the SUBTERM and believe you will get the correct result.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |