Forum Discussion

Sagejah9's avatar
Sagejah9
Icon for Helper III rankHelper III
5 years ago
Solved

adding a measure to matrix column beside a table column

I would like to add a measure to my matrix next to the other columns. If I add the measure to the values tab in the visulation pane. it will fall under each Attribut column in the matrix.  the m...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Sagejah9 ,

     

    You can use the subtotals to show the value.

     

    Create the following measure

    Measure = IF(ISINSCOPE('Table'[Attribute]),SUM('Table'[Value]),DIVIDE(CALCULATE(SUM('Table'[Value]),FILTER('Table',[Attribute]="SubjectA"||[Attribute]="SubjectD")),2))

    You can change the name of subtotals.

     

    Check more details from the attchment.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.