Forum Discussion

Irwin's avatar
Irwin
Helper IV
4 years ago
Solved

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 separ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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