Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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[ParameterName]).
These measures serve as the column headers in a table. The rows are formed using a calculation group calculating that measure over different weeks in that month, the maximum weekly average, if the parameter is ph of Dissolved Oxygen, report the Min or Max value recorded, etc.
Problem:
Certain Calculation Items are not returning values when using SELECTEDVALUE(). This is a problem because i am attempting to conditionally format based on the Calculation Item.
Here a simple version of the table i am using to troubleshoot:
The measure for the SelectedValue column is
This returns nothing? blank? empty? not sure...
However this calc item returns the name.
Am i missing something?
Hello @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.
User | Count |
---|---|
21 | |
20 | |
13 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
13 | |
12 | |
11 |