Reply
Regular Visitor
Posts: 23
Registered: ‎07-13-2018
Accepted Solution

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

Filters1.JPG


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

Re: If not selected

@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

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.

View solution in original post


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

Re: If not selected

@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

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.