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 a data like this
I have created a measure count# = distinctcount(#Req)
Now how can i achieve max count # ?
I have tried
calculated(maxx(table,count#),allexcept(table,Item))
i just couldt get the result.
Solved! Go to Solution.
Hi @Anonymous
Assuming the second image you show is a table/matrix visual, you can create a measure like this:
max count # = MAXX ( ADDCOLUMNS ( ALL ( Table1[Item] ), "_Res", [count#] ), [_Res] )
where [count#] is the measure you already have:
count# = DISTINCTCOUNT(Table1[#Req])
and Table1 is the first table you show.
On a different note, please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here.
Hi @Anonymous
Assuming the second image you show is a table/matrix visual, you can create a measure like this:
max count # = MAXX ( ADDCOLUMNS ( ALL ( Table1[Item] ), "_Res", [count#] ), [_Res] )
where [count#] is the measure you already have:
count# = DISTINCTCOUNT(Table1[#Req])
and Table1 is the first table you show.
On a different note, please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here.
Hi Thanks, it works perfectly!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |