Forum Discussion

plmiquelon's avatar
plmiquelon
Frequent Visitor
4 years ago
Solved

Matrix subtotals

Hi, I would like the following matrix to sum the numbers in each column.   The idea is that I have a project list (hidden by the green rectangle) with start date of each phase. I have a switch meas...
Need Help
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, plmiquelon ；

    You could create another measure.

    Measure 2 = 
IF(HASONEVALUE('Table'[Date]),
  IF(ISINSCOPE('Table'[Shop]), [Phase1],SUMX('Table',[Phase1])),
     SUMX('Table',[Phase1]))

    The final output is shown below:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, plmiquelon ；

You could create another measure.

Measure 2 = 
IF(HASONEVALUE('Table'[Date]),
  IF(ISINSCOPE('Table'[Shop]), [Phase1],SUMX('Table',[Phase1])),
     SUMX('Table',[Phase1]))

The final output is shown below:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.