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 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.