Ratio calculation of month vs full year - need help

[discrate]

Hi,

I have a BI matrix visualization with values in yearly/monthly structure and would like to have a column in which the ratio of each monthly data is being calculated vs the total year.

The only way I was able to calculate the yearly total figure is:

TotalSalesCY = CALCULATE([TotalSales],PARALLELPERIOD(DimDate[Date].[Date],0,YEAR))

Then I could divide the TotalSales by TotalSalesCY.

Is there any other/easier way to override the current monthly filter context (and just have the year filter) when populating data in TotalSalesCY column?

Thank you.

[Greg_Deckler · Accepted solution]

Not sure it is easier but perhaps:

TotalSalesCY = CALCULATE([TotalSales],ALLEXCEPT(DimDate,DimDate[Year]))

If you have a Year column in DimDate.

[discrate]

Thank you Greg for your quick and helpful reply! This has the same result and formula is exactly what I needed: an other method (ALLEXCEPT) which I can use in other context as well.

Cheers

[Greg_Deckler]

??

[discrate]

Accidently was posted without body. I have edited the post.