Forum Discussion
Overall Total Correct, but Drilling down Incorrect
I'm having an issue with a calculation. Total Defects:=CALCULATE([All Events],Defects[CA ID]<>"0_DEFECTS",Defects[DISPO_CD]<>"2X -Accept As is(Conforming)",Defects[Begins 0]<>"TRUE") This giv...
Hi groffia,
What visual do you use with drill Down?
By my test in matrix, it seem that I could reproduce your issue like below. Do you mean the total value are all the same for the Drill down?
If I miss something, could you show some screenshots to specify your problem?
I would appreciate it if you could share your expected output.
Best Regards,
Cherry
I'm just using basic Excel... some people in this company (old school people) still like the old graphs... so a slicer here and there... and they get what they're looking for. In this particular situation... I only have a slicer for the year displaying...
See attached pics for the wrong and right graphs... the wrong one should be obvious.
rightwrong