Sub total for per category row

[Anonymous]

Ideally i would like the # sales to stay per date given but the $ Sale to be show as a totalThis how i hope to have the matrix look. This is using two matrices and formatting it correctly

I am new to Power BI and I am trying to insert values into a matrix but I only want the value to be displayed as a total. I have the

dates in my columns and the value is showed per dates - I only want the total to be displayed for that particular row

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I'd like some sample data and expect result to help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

For replace total level display value, you can refer to following blog to know how to add condition to check if current row contents is total level, then write correspond measure formula to calculate.

Clever Hierarchy Handling in DAX - SQLBI

Regards,

Xiaoxin Sheng