Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have data similar to the following:
While I'm able to get a Location_Measure max Number by Location, I don't quite understand the SUMMARIZE or GROUPBY function with MAXX to get the maximum number by City or Country.
Desired output is a City_Measure that equals 130 and Country_Measure that equals 180
Country | City | Location | Number |
USA | NY | A | 10 |
USA | LA | B | 65 |
USA | LA | C | 65 |
UK | London | D | 60 |
UK | London | E | 60 |
UK | Brighton | F | 60 |
Solved! Go to Solution.
how do you want to use this data?
something like this could work but depending on how you using it
Proud to be a Super User!
Thanks so much. The output will be used in a measure or a card. This is exactly what I needed!
how do you want to use this data?
something like this could work but depending on how you using it
Proud to be a Super User!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |