topic SELECTEDVALUE() with Calculation Groups sometimes returning blanks(?) when used in a table in DAX Commands and Tips

SELECTEDVALUE() with Calculation Groups sometimes returning blanks(?) when used in a table

tp365 — Wed, 22 Jan 2025 15:27:39 GMT

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

SelectedValue = SELECTEDVALUE(Group1[Calculation])

I dont think the blanks are actual blanks, because when i write a measure saying If its blank, display something else, that doesn't work either. Neither does a blank string.

Focusing on MAX Weekly Avg - the calculation item is:

This returns nothing? blank? empty? not sure...

However this calc item returns the name.

Am i missing something?

Re: SELECTEDVALUE() with Calculation Groups sometimes returning blanks(?) when used in a table

Sahir_Maharaj — Wed, 22 Jan 2025 20:43:58 GMT

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] ) )

Re: SELECTEDVALUE() with Calculation Groups sometimes returning blanks(?) when used in a table

tp365 — Wed, 22 Jan 2025 21:09:13 GMT

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.

Re: SELECTEDVALUE() with Calculation Groups sometimes returning blanks(?) when used in a table

nk1025 — Fri, 14 Mar 2025 17:07:09 GMT

tp365 were you ever able to resolve this issue? I think this behavior is currently impeding my attempts to implement conditional formating for my calculation groups as well.

Re: SELECTEDVALUE() with Calculation Groups sometimes returning blanks(?) when used in a table

Nina123 — Tue, 01 Apr 2025 10:03:30 GMT

I am experiencing this issue as well. Even when I try SELECTEDVALUE('Calculation group'[Ordinal]), it does not give the ordinal.

What I did to solve it was: create a new table which summarizes the calculation group table. Create a relationship between the calculation group table and the new table. And use the new table columns in measurs for conditional formatting.

Re: SELECTEDVALUE() with Calculation Groups sometimes returning blanks(?) when used in a table

alibaba_42 — Fri, 16 May 2025 12:30:48 GMT

Hi Nina123 ,
I would be glad to see your solution in detail.