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 "sollicitat...
Need Help
  • Anonymous's avatar
    Anonymous
    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 ()
)