Forum Discussion

Boycie47's avatar
Boycie47
Regular Visitor
3 years ago
Solved

Cumulative Grand Total Column Matrix Table

Hi,   I am hoping someone can help.   I have a matrix visual and I would like to apply the column grand total but it is giving me the total based on the measure I am using an not the cumulative t...
  • amitchandak's avatar
    amitchandak
    3 years ago

    Boycie47 , Try a new measure like

     

    Sumx(values(Table[Area]), [Measure])

amitchandak's avatar
amitchandak
Super User
3 years ago

Boycie47 , Try a new measure like

 

Sumx(values(Table[Area]), [Measure])

Boycie47's avatar
Boycie47
Regular Visitor
3 years ago

amitchandak thank you very much 🙂