Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi community !
it's almost a shame to ask this easy peasy one but it's late here 🙂
I want to calculate some kind of a GroupBy measure like this :
Country | City | Nb | Measure_to_build |
Spain | Madrid | 10 | 25 |
Spain | Barcelona | 10 | 25 |
Spain | Alicante | 5 | 25 |
Italy | Roma | 8 | 12 |
Italy | Turin | 2 | 12 |
Italy | Florence | 2 | 12 |
I struggled a bit with CALCULATE and FILTER... but it'll be more effective from here !
Thank youuuu
Stephane
Solved! Go to Solution.
Keep in mind a table like you're showing will "filter" to the rows of the city.
You could try something like this:
Keep in mind a table like you're showing will "filter" to the rows of the city.
You could try something like this:
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |