Forum Discussion
Table Measure Totals - Again
I'm trying to calculate the total difference between two grading distributions (MIs). One group, ALL, is across all trainees, and the other, Cell/Value, is for just a selected trainee (cross-filtere...
Can you change the CIS formula to the following one and see if it works?
CIs = SUMX (
VALUES ( 'FACT-ELEMENTGRADES'[GradeValue] ),
ABS([% Graded MI Distribution (Value)]-[% Graded MI Distribution (Value-All MenuItems)])
)
That results in a CIs total but does not return the two rows where no grades were awarded (1 and 2):
I suspect that has to do with the fact that the individual selected (cross-filtered and has no grades of 1 or 2) is causing VALUES is returning a blank value for those two entries.
Values calculation is returning a blank for grades of 1 and 2 and not including the calculated CIs for those two in the total. Any workarounds?