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...
Custom Visuals
Dashboards
Reports
  • 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

Anonymous's avatar
Anonymous
Not applicable
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