Forum Discussion
Sub total for per category row
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
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
1 Reply
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