Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help with matrix table measures

.
Anonymous's avatar
Anonymous
Not applicable
4 years ago

.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous OK, see PBIX attached below signature. The basic measure is:

 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Greg_Deckler Thank you so much for this. Can we also show the AMs count with the wins, target and percentage? 

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      4 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
        4 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?