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
Super 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))

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for you Quick reply .

I want to calculate Item percentage contribution  to Subcategory level and I don’t want to show Subcategory in my report. I want to see 450 and 600 in the place of 900 and 1200 in my table chart to calcuate the same.

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous change your grand sales measure as below

     

    Grand Total of Sub Sales = SUMX( ALLSELECTED( SalesInfo[ProductName] ), [Total Sales] )
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for You reply,

      I have attahced the output of your experssion and i am getting 1050 as output . As i expalined earlier ,

      I want to calculate Item percentage contribution  to Subcategory level and I don’t want to show Subcategory in my report. I want to see 450 and 600 in the place of 900 and 1200 in my table chart.