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 All,
I have a table with a few measures and until now it gives me what I need but I've hit a rock because of filtering.
Below the table:
Tabe is split by region. First row is a measure (named CAT Cost) that gives above numbers and that's fine. Second is the same but as % of grand total. However I need this percentage of grand total in a measure as I need it for further calculation (to multiply it with other things). How I am using it it currently also filter by region and this is not what I need
Is there a way to do simple measure like this
CAT COST*/sum(CAT COST) to get percentage of grand total?
*This will still be filtered by region
note that there are a few filters in the measure and on the page leve which I need to keep.
Can you just add the measure again, use the drop down in the Fields area and choose "Show as | Percent of Grand Total"?
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |