display total in matrix visual

[Ajeck]

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 · Accepted solution]

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]

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