Forum Discussion

Milozebre's avatar
Milozebre
Helper V
8 years ago
Solved

Filter on empty value

Hello,    I want to create a measure with filters and one on the values.    I want to calculate the numbers of cases where the field 'Dossiers'[L=comment] is not empty   Calculate( Distinctcoun...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Milozebre,

     

    Please try this:

    Measure=CALCULATE(DISTINCTCOUNT('Dossiers'[Case]),FILTER('Dossiers','Dossiers'[L=comment]<>BLANK()))

     

    Regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Milozebre,

 

Please try this:

Measure=CALCULATE(DISTINCTCOUNT('Dossiers'[Case]),FILTER('Dossiers','Dossiers'[L=comment]<>BLANK()))

 

Regards,

Yuliana Gu

Milozebre's avatar
Milozebre
Helper V
8 years ago

Hello, 

 

First Merry Christmas :) 

 

Sorry for the late response.

 

Thank you for your help