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 of multiple weeks at item level).

2. Sum of Average item to Subcategory level

3. I will not  use Subcategory in my Table report.

I am expecting Subtotal of Subcategory as

450 for Individaul Person 

600 for Legal Person

 

Currently it is 900 and 1200.

 

https://drive.google.com/file/d/1oJ7-_hzOUOMo8yBbpZJm20f1BA4c35mP/view?usp=sharing

Need Help

4 Replies

  • 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] )