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( Distinctcount('dossiers'[Case]) --> I use distinctcount because I have several cases with the same number. 

but how to insert the rest 

 

can you help me ? 

 

Thank you 

 

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

2 Replies

  • 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