Forum Discussion

Ajeck's avatar
Ajeck
Helper III
10 months ago
Solved

display total in matrix visual

Hi....,

 

I make a matrix visualisation like this : 

How can i get the total  for Premi and Acv ?

noted Acv = Achievement, LY = Last year

 

Thankyou

 

Rgds

Aji

 

  • vivien57's avatar
    vivien57
    10 months ago

    Hello Ajeck ,

    Try this : 

    Total Premi = SUM('Table'[Premi])
Total Acv = DIVIDE(SUM('Table'[Premi]), SUM('Table'[Plan]))

     

    and use these result columns in your table instead of the one you are currently using

    Have a nice day,

    Vivien

2 Replies

  • vivien57's avatar
    vivien57
    Super User
    10 months ago

    Hello Ajeck ,

    Try this : 

    Total Premi = SUM('Table'[Premi])
Total Acv = DIVIDE(SUM('Table'[Premi]), SUM('Table'[Plan]))

     

    and use these result columns in your table instead of the one you are currently using

    Have a nice day,

    Vivien

    • Ajeck's avatar
      Ajeck
      Helper III
      10 months ago

      Hi vivien57 ,

       

      Thankyou, It's Work, 

      Previously I used this : 

      Premium MTD TM = TOTALMTD([Premi],'PowerBI DimDate'[Date])
      so i change it becomes : 
      Total Premi = SUM('Table'[Premi])​

      and it's work, 

       

      Thankyou

       

      Rgds

      Ajeck