## Desktop

Regular Visitor
Posts: 23
Registered: ‎07-13-2018

# If not selected

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

Accepted Solutions
Highlighted
Moderator
Posts: 9,577
Registered: ‎03-10-2016

## Re: If not selected

@aryan,

`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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

All Replies
Highlighted
Moderator
Posts: 9,577
Registered: ‎03-10-2016

## Re: If not selected

@aryan,

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