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

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