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.
Hello All,
Need your help! Is there any way that I can capture the name of crime which has max counts? With below case it should show Burglary of vehicle since its count is 715. I have a measure which gets the value of max count = 715 but not sure how to write anothet measure which will show the value corresponding to this value.
Please advise, thanks!
Solved! Go to Solution.
Hi @harshadsp
Assuming your Table name is "CrimeData", try this measure
Most Common Crime = VAR Maxvalue = MAXX ( SUMMARIZE ( CrimeData, CrimeData[CrimeType], "Count", COUNT ( CrimeData[CrimeType] ) ), [Count] ) RETURN CALCULATE ( VALUES ( CrimeData[CrimeType] ), FILTER ( VALUES ( CrimeData[CrimeType] ), CALCULATE ( COUNT ( CrimeData[CrimeType] ) ) = MaxValue ) )
Can you please tell me how did you create the measure that shows you the max count - 715 ?
Thanks
Hi, I used the following formula to get the max value.
Measure = MAXX ( VALUES ( table[column1] ), CALCULATE ( COUNT ( table[column2] ) ) )
Hope this helps, else please write again. Thanks
It works. Thank you.
Hi @harshadsp
Assuming your Table name is "CrimeData", try this measure
Most Common Crime = VAR Maxvalue = MAXX ( SUMMARIZE ( CrimeData, CrimeData[CrimeType], "Count", COUNT ( CrimeData[CrimeType] ) ), [Count] ) RETURN CALCULATE ( VALUES ( CrimeData[CrimeType] ), FILTER ( VALUES ( CrimeData[CrimeType] ), CALCULATE ( COUNT ( CrimeData[CrimeType] ) ) = MaxValue ) )
When there are multiple values for Most Common Crime, it's not working.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |