Forum Discussion

Lauraeire_81's avatar
Lauraeire_81
Helper I
1 year ago
Solved

Where values are blank()

Hi I've created a measure where I need it to calculate distinct count of values where values are 'yes', if filter is selected and 0 if no filter. I would like to show '0' or 'No values' if there ar...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Lauraeire_81 Try using

     

    DAX
    Measure 5 =
    IF(
    ISFILTERED('Report Results'[Systems]),
    IF(
    ISBLANK(
    CALCULATE(
    DISTINCTCOUNT('Report Results'[ServerN]),
    'Report Results'[Out of Support] = "yes"
    )
    ),
    0,
    CALCULATE(
    DISTINCTCOUNT('Report Results'[ServerN]),
    'Report Results'[Out of Support] = "yes"
    )
    ),
    0
    )

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

Lauraeire_81 Try using

 

DAX
Measure 5 =
IF(
ISFILTERED('Report Results'[Systems]),
IF(
ISBLANK(
CALCULATE(
DISTINCTCOUNT('Report Results'[ServerN]),
'Report Results'[Out of Support] = "yes"
)
),
0,
CALCULATE(
DISTINCTCOUNT('Report Results'[ServerN]),
'Report Results'[Out of Support] = "yes"
)
),
0
)

  • Lauraeire_81's avatar
    Lauraeire_81
    Helper I
    1 year ago

    Thanks this is perfect.