Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |