topic display total in matrix visual in Custom Visuals Development Discussion

display total in matrix visual

Ajeck — Tue, 07 Oct 2025 06:32:24 GMT

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 — Tue, 07 Oct 2025 10:03:08 GMT

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 — Tue, 07 Oct 2025 10:19:22 GMT

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