If not selected

[aryan]

Hi!

I have created 3 measure and a Filter X,Y,Z and Measures with sum(A),Count(A)

last measure is IF(Selectedvalue(Filter)=X,Sum(A),IF(Selectedvalue(Filter)=Y,count(A),IF(Selectedvalue(Filter)=Z,count(A)))) this is working perfectly when i select any Filter But when i don't select any filter it is showing empty, but i wan too display  Totalcount(A)else empty

I have tried alot with other dax frmulas but i am not able t get the output can u please help to solve this

Here i am giving sme sample data

[v-yuezhe-msft · Accepted solution]

@aryan,

Please change your DAX to the following:

Measure= IF(Selectedvalue(Table[Filter])="X",Sum(A),IF(Selectedvalue(Table[Filter])="Y",count(A),IF(Selectedvalue(Table[Filter])="Z",count(A),SUM(A))))

Regards,
Lydia