Forum Discussion
Matrix with measure based on row sums
Hi I have two sets of values (X and Y) that vary by Month and Year. I am trying to build a matrix of Columns=Month and Rows=Year, where the values use a measure: X / (sum of Y for entire year) Eg...
Anonymous , You can try measure like, But prefer a separate year month table
This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('YearMo'),'YearMo'[Year]=max('YearMo'[Year])))
amitchandak
Super User
Super UserAnonymous , You can try measure like, But prefer a separate year month table
This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('YearMo'),'YearMo'[Year]=max('YearMo'[Year])))
thank you very much!!