Forum Discussion

Reimer's avatar
Reimer
Helper II
5 years ago
Solved

Use Filter in DAX

Hi all,

 

I am having a problem with filter in Power BI

 

I have a dataset called "Procedure - Power BI". In this dataset is a column called "aantal sollicitanten" and a column called "sollicitatie na start".

 

How do I only count the "aantal sollicitanten" if "Sollicitatie na start" is a number below 7?

 

Can anyone help?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Measure = CALCULATE(COUNT('Table'[aantal sollicitanten]),FILTER('Table','Table'[Sollicitatie na start]>7))

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Measure = CALCULATE(COUNT('Table'[aantal sollicitanten]),FILTER('Table','Table'[Sollicitatie na start]>7))

    • Reimer's avatar
      Reimer
      Helper II
      5 years ago

      Thank you so much!

       

      Just a quick follow-up question. If I just wanted to count the fields with no entry, what would the measure be?

      • Angith_Nair's avatar
        Angith_Nair
        Continued Contributor
        5 years ago

        Hi Reimer ,

        With no entry means, that value will be blank. For that try this measure..

        Measure =
CALCULATE (
    COUNT ( 'Table'[aantal sollicitanten] ),
    'Table'[Sollicitatie na start] = BLANK ()
)