IF statement with filter?

Question

Hi guys,&nbsp;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 &gt;=10000 (with a date slicer separate).I have for now made this dax measure which works fine.&nbsp;Measure = CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTA ('Table'[Row]), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(ALL('Table'[Row]), 'Table'[Row]&gt;=10000))&nbsp;However, sometimes there are no values &gt;=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?&nbsp;Measure =IF (&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COUNTA ( 'Table'[Row] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] &gt;= 10000 )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= BLANK ()&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; 0,&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COUNTA ( 'Table'[Row] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] &gt;= 10000 )&nbsp; &nbsp; &nbsp; &nbsp; ))&nbsp;&nbsp;Thanks a bunch.

anonymous · Accepted Answer

Irwin&nbsp;You should close parenthesis in the first CALCULATE:Measure =IF (&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COUNTA ( 'Table'[Row] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] &gt;= 10000 ) )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= BLANK ()&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; 0,&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COUNTA ( 'Table'[Row] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER ( ALL ( 'Table'[Row] ), 'Table'[Row] &gt;= 10000 )&nbsp; &nbsp; &nbsp; &nbsp; ))

Forum Discussion

IF statement with filter?

2 Replies

Related content

IF Statement with Filter

OR Statement ?

SQL Statement opcion error

Return Filter from Switch Statement DAX

SUMX with Filter or If Statement