Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |