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 need to create a measure that calculates how many unique items in a table have a MAX value of a certain number. I am trying to put the results inside of a Card visual.
As an example, I am wanting a count of the unique IDs in the following table that have a max status of 3, which should just be a count of 1:
ID Status
1001 1
1002 2
1001 3
1002 1
Solved! Go to Solution.
Hi @Anonymous
You can create measure Count_Max to meet your demand.
Count_Max = CALCULATE(DISTINCTCOUNT(Table1[Status]),FILTER(ALLSELECTED(Table1[Status]),Table1[Status]=MAX(Table1[Status])))
Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EePkU0bR6bNFqU3SZcJ5Z14B60swKEmgtNy5Wj9G9ME2Qw?e=ee9Oe2
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You can create measure Count_Max to meet your demand.
Count_Max = CALCULATE(DISTINCTCOUNT(Table1[Status]),FILTER(ALLSELECTED(Table1[Status]),Table1[Status]=MAX(Table1[Status])))
Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EePkU0bR6bNFqU3SZcJ5Z14B60swKEmgtNy5Wj9G9ME2Qw?e=ee9Oe2
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering 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 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |