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.
Hello Community,
I encounter an issue where I have a matrix chart with category and subcategory and for example if I have a slicer for wether category or subcategory and I select something the total is gonna show the one for every subcategory/category.
Posting some snapshots of my matrix chart and the measure I use for it.
hi @Anonymous
whay not just using SUM of the [Result] column? Why do you need a calculated column for each type of aggregation? This is supposed to happen automatically inside the matrix!
this is what is happening when I do that, basically because I need a sum for subcategory and an avg for a category and a total
@Anonymous
Apologies. This should be AVERAGE not sum
not working even with average
@Anonymous
Can we connect via teams or zoom?
I'll see if it's possible
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 |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |