Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
Measure = CALCULATE(COUNT('Table'[aantal sollicitanten]),FILTER('Table','Table'[Sollicitatie na start]>7))
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 ()
)
User | Count |
---|---|
117 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
62 | |
55 |