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:
Go to Solution.
Not sure it is easier but perhaps:
TotalSalesCY = CALCULATE([TotalSales],ALLEXCEPT(DimDate,DimDate[Year]))
If you have a Year column in DimDate.
Proud to be a Datanaut!
View solution in original post
Accidently was posted without body. I have edited the post.
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.
Do you need help in Spanish? Check out our new Spanish community section.
Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.