Forum Discussion
Measure not displaying correct value in Total Row
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
Hey,
I'm wondering if this will provide what you are looking for ...
My data model (I do not conisder the table DAX measures)
My measure "Total Sales (Baseline)" looks like this
Total Sales (Baseline) =
SUMX(
VALUES(Main_Data[Project])
,IF(NOT(ISBLANK([Total Sales]))
,CALCULATE (
SUM ( Main_Data[Sales] )
,ALL(Snapshot[Snapshot])
,ALL('Status'[Status])
,Snapshot[Snapshot] = "Baseline"
,'Status'[Status] = "Baseline"
)
,BLANK()
)
)
Using this measure the matrix looks like this:
Please be aware that the slicers are using the dedicated tables (dimension tables), and that I'm also using the status column from Status table in the matrix visual.
Hopefully this is what you are looking for.
Regards,
Tom
Thanks Tom,
This could be it!
Could you send back the pbix file. I've tried to replicate the results, but instead, now the total rows show, but the rows beneath come up as blank...
Hi Tom,
Here is my updated pbix file.
Can you see where I am going wrong?
KR,
Sachin
I think I solved it. I wasn't using the Status field from the Status slicer in the Matrix Table!
It seems to work now.
Thank you!
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