Forum Discussion
Solved
Measure not displaying correct value in Total Row
Hi, I'm truly stumped with this one. I am trying to show the sales for different products, and brands, for different months. I have created measures, as I also want to be able to show the sal...
I tried creating a separate dimension table for Status, but now get completely bogus behaviour!
See attached:
Perfect!
Please mark the most appropriate post as an answer, this will help others! And you might also consider to give that post a kudo, if it saved you headache and time ;-)
Cheers,
Tom
I've set bi-directional filtering on between the Status Table and Main Sales Table which seems to help, but still trouble with the totals not adding up the rows beneath, when the status slicer is used
Sachin
Maybe I need a more sophisticated measure for the total rows...
Reading this... https://www.daxpatterns.com/parent-child-hierarchies/
But still scratching my head... : (