topic Getting a Measure to read ZERO (0) when the slicers read all selected in DAX Commands and Tips

Getting a Measure to read ZERO (0) when the slicers read all selected

cflynn_29 — Thu, 23 Apr 2020 18:33:39 GMT

Hi All,

I have the following measure

2.6 = MAXX(VALUES(Data[School]), [Area max per School])

Table - Column - Measure

But when the School Filter reads ALL i would like to read (0) until a school is selected. Will a selected value work? Or anything really i havent been terrbily successful.

Thank you,

Re: Getting a Measure to read ZERO (0) when the slicers read all selected

sturlaws — Thu, 23 Apr 2020 21:06:10 GMT

Hi cflynn_29

have you tried to write your measure like this?

2.6 = if(hasonevalue(data[school]),MAXX(VALUES(Data[School]), [Area max per School]),0)

Cheers,
Sturla

Re: Getting a Measure to read ZERO (0) when the slicers read all selected

Anonymous — Fri, 24 Apr 2020 14:34:49 GMT

Don't understand why there's MAXX in there... This returns the same output:

if( hasonevalue( data[school] ), [Area max per School], 0 )

which can also be compacted to:

hasonevalue( data[school] ) * [Area max per School]

The two (and the one given by sturlaws) are exactly the same.

Best