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

[cflynn_29]

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,

[sturlaws · Accepted solution]

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

[Anonymous]

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

D