Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help with matrix table measures

.
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous I don't see why not. Updated PBIX below that also shows this in a matrix visual.

 

Total = "Wins - " & SUM('sample'[WIGS_Wins_Achieved])+0 & ", Target - " & SUM('sample'[WIGS_Target])+0 & ", " & FORMAT([%]+0, "0.00") & "%, AMS - " & [ams]

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Greg_Deckler in the sample pbix file, the first table has total right. Can we have this measure which looks like the row subtotals? so that even if we expand the hierarchy, the new measure which represents the total should also be placed accordingly like this:

 

 

Is this possible?

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous I don't understand what you are saying.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      .

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        3 years ago

        Anonymous I don't see it happening or if it is possible it is going to be incredibly ugly to code. Basically what you are asking for is akin to a Custom Matrix Hierarchy except instead of the hierarchy being for columns, you need it for rows. Knock yourself out with this method if you can swing it: (3) The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community