Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Add New total row

I have a a measures for all sales values and customer group is a calculated column.

I need to add another total for Veritiv and USA only after USA. Is this possible in matrix visual using Dax.

Please help!

 

 

  • Anonymous - Sort of, you will want to create a Group for Veritiv and USA and groups for Others and International and use the Group hierarchy in your rows. This provides subtotal rows if you want them.

2 Replies

  • Anonymous , the calculation is not clear for that.  See if segmentation can help

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous - Sort of, you will want to create a Group for Veritiv and USA and groups for Others and International and use the Group hierarchy in your rows. This provides subtotal rows if you want them.