Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |