Forum Discussion
SELECTEDVALUE() with Calculation Groups sometimes returning blanks(?) when used in a table
Hey All, I am trying to build a report for water quality reporting. Context: I have several parameters that are evaluated using a measure that is just ParameterName = AVERAGE(Parameter[Paramet...
Thanks for the reply Sahir_Maharaj.
The suggested Calculation Item does give the appropriate maximum weekly average, however the SelectedValue is still blank.
Oddly enough, the ordinal will populate, but when used in a conditional format, it doesn't register at all, even under the "else" condition.
Here is the Measure i am applying as conditional formatting using field values for the column represented here:
It does not recognize if i use SelectedValues(DMR[Calculation]) or SelectedValues(DMR[Ordinal]) for [MAX Weekly Avg] even though the ordinal actually populates.
