Forum Discussion

aryan's avatar
aryan
Helper I
7 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    7 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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