Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Grouping at Different Levels

Hi Guys, I have attahced the link to my PBIX file and my requiremet is to populae the subcategory total sales to calculat the percentage. 1. First i need to calculate Average at Item level(Average ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous change your Total Sales measure as below

 

Total Sales = 
SUMX( VALUES( SalesInfo[ProductName]), CALCULATE(Average( SalesInfo[SalesAmount] ),
WeekCal[YearNum]<=201914,WeekCal[YearNum]>=201913))