Forum Discussion
Total %
Keep your [Sales Last 5 Quarters (Axis)] measure.
Create quarter total:
Total Sales per Quarter =
CALCULATE (
[Sales Last 5 Quarters (Axis)],
REMOVEFILTERS ( 'Manager'[Name], 'Category'[Category] )
)
% measure:
Sales % of Quarter =
DIVIDE (
[Sales Last 5 Quarters (Axis)],
[Total Sales per Quarter]
)
Use Sales % of Quarter in your matrix → it will give the percentages exactly like your required output.
Shahid12523 , for me manager name and Items are coming from two different table. And when i use the dax that you share. i am getting every thing as 100%.
https://community.fabric.microsoft.com/t5/Desktop/Last-3-quarter/m-p/4806171#M1429711
the current solution of getting the numbers is from the above link. i think we may have to alter the "Total Sales per Quarter " Dax as the manger name and item names are coming from two different tables.