Forum Discussion
Row Level Totals Blank when adding Measure Names to rows in Matrix visual
You are using Selectedvalue on the measure name, on the grandtotal the measure name is not filtered and you have all three measures in scope, resulting in blank. Therefore you switch goes to the else statment, returning blank
Hi Deku Thanks for your response. How to resolve this instead of using switch. Could you please help me create the correct DAX to get the grand totals too? Thanks!
what would be expected for the grandtotal? the sum of all of the three measures? do grand totals make sense in this situation?
Hi Deku No. I want to see the total wrvus, total wrvus per visits and total deficit wrvus separetely which am getting like this below when I select multiple providernames. But this is just a normal matrix with no measure names added and filtering of measures is not possible from this matrix.
Filtering is possible only when the measure name and selected measure is added instead of individual measure. Thanks!