Forum Discussion

Anonymous

Not applicable

4 years ago

Need Help with Dax

Hi I am trying to calculate a measure that should show the value of the measure in the visual if the selected year is 2022, else it should should as "Not Applicable". Here is the Dax I've use...

Jihwan_Kim

Super User

4 years ago

Hi,

I am not sure how your DimDate table looks like, but I assume your year column is not Text Type.

Please try to replace "2022" to 2022.

Count of Manager =
IF (
    SELECTEDVALUE ( Dim_Date[Year] ) = 2022,
    CALCULATE (
        DISTINCTCOUNT ( EmployeeMaster[Manager Id] ),
        FILTER ( EmployeeMaster, EmployeeMaster[Employee Status] = "Active" )
    ),
    "Not Applicable"
)