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 |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |