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...
Sahir_Maharaj
Super User
Super UserHello tp365,
Can you please try this approach:
MAX Weekly Avg =
IF(
OR(
CONTAINSSTRING(SELECTEDMEASURENAME(), "Eff pH"),
CONTAINSSTRING(SELECTEDMEASURENAME(), "Eff DO")
),
BLANK(),
MAXX(
ADDCOLUMNS(
VALUES('Calendar'[DMR Week]),
"WeeklyValue", CALCULATE(SELECTEDMEASURE())
),
[WeeklyValue]
)
)
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.
