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,
Hope you're all doing well.
Is it possible to achieve something like this: I'd like to be able to display a total value based on multiple columns where the total will vary depending on the columns I'd like to sum by using a filter.
As an example I have this data set called 'tbl_Totals':
And I've created a measure that sums the totals like this:
Grand Total = SUM('tbl_Totals'[Pants]) + SUM('tbl_Totals'[Shirts]) + SUM('tbl_Totals'[Shoes])
Which on a table looks like this:
I'm trying to create a filtering approach where I can change the grand total based on the fields I select. So if I select 'Shoes', the Grand Total will be 80. Or, if I select 'Pants' and 'Shirts', the grand total will change to 125. Example:
'Shoes' only:
'Pants' & 'Shoes':
I just made up the slicers as a demonstration.
Thanks in advance!
@aridavid - Maybe, it's not very clear though. You would probably have more luck if you unpivoted those columns in your dataset. If you do need multi-column aggregation, there is a way to do it. https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...
And the solution comes with a nice poem...
Hey, thanks for checking, I'll try to edit and clarify.
@aridavid , not very cleat.
You can unpivot the data and use
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
hanks for the hint, I'll try to clarify.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |