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.
Hi,
I'm new to this, sorry if this one is easy.
I'd like to go from this:
To this:
Basically consolidate the Counts by Year, Crime and Community.
Thanks so much for your help!
Solved! Go to Solution.
Proud to be a PBI Community Champion
If you need it as a table
NewTab = SUMMARIZE(Table, Table[Community], Table[Year], Table[Crime], "Count", SUM(Count) )
If you just want it as a measure
Measure = CALCULATE( SUM ( Table[Count] ) )
The measure will recalculate at any level (say, community and crime only)
Hope this helps
David
Proud to be a PBI Community Champion
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |