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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Irwin
Helper IV
Helper IV

IF statement with filter?

Hi guys,

 

I have a table with values ranging from blank, 0, 100, 200.... and so forth.

I would like to create a measure that displays my how many values that are >=10000 (with a date slicer separate).

I have for now made this dax measure which works fine.

 

Measure =
CALCULATE (
          COUNTA ('Table'[Row]),
          FILTER(ALL('Table'[Row]), 'Table'[Row]>=10000)
)
 
However, sometimes there are no values >=10000 and the measure will display "Blank". I dont want this. I would like it to write 0.
When I try to use an IF function PBI tells me that filters and IF functions (true/false) are not allowed... Any suggestions?
 
Measure =
IF (
        CALCULATE (
               COUNTA ( 'Table'[Row] ),
               FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] >= 10000 )
                       = BLANK ()
        ),
        0,
        CALCULATE (
               COUNTA ( 'Table'[Row] ),
               FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] >= 10000 )
        )
)
 
 
Thanks a bunch.
1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Irwin You should close parenthesis in the first CALCULATE:

Measure =
IF (
        CALCULATE (
               COUNTA ( 'Table'[Row] ),
               FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] >= 10000 ) )
                       = BLANK ()
        ),
        0,
        CALCULATE (
               COUNTA ( 'Table'[Row] ),
               FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] >= 10000 )
        )
)

View solution in original post

2 REPLIES 2
Irwin
Helper IV
Helper IV

You are right of course. **bleep**... I moved those parenthesis around so much already 😉

Thank you for helping! 🙂

Anonymous
Not applicable

@Irwin You should close parenthesis in the first CALCULATE:

Measure =
IF (
        CALCULATE (
               COUNTA ( 'Table'[Row] ),
               FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] >= 10000 ) )
                       = BLANK ()
        ),
        0,
        CALCULATE (
               COUNTA ( 'Table'[Row] ),
               FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] >= 10000 )
        )
)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.