Use Filter in DAX

[Reimer]

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?

[Anonymous · Accepted solution]

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

[Reimer]

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]

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 ()
)