Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Reimer
Helper II
Helper II

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?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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

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?

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.