cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aryan Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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.
1 REPLY 1
Moderator v-yuezhe-msft
Moderator

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.