Forum Discussion

udian's avatar
udian
Icon for Helper III rankHelper III
10 years ago

DAX Calculate Percentage from Column Total

I am trying to build a tabular cube measure that will always calculate the percentage from the column total even when using a matrix.   In the example attached i would like to get X % of Tota...
DAX
percentage
LaurentCouartou's avatar
LaurentCouartou
Icon for Solution Supplier rankSolution Supplier
10 years ago

You cannot detect what is on rows or what is on columns in DAX, so you cannot do a true "Column Total". However, something like this, may work for you:

 

SUM(Salse_Quantity) /

Calculate(SUM(Salse_Quantity)
      ,Product
      ,ALLSELECTED()
)