Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count and filter numeric values only

Hi guys,    Im crushing my head with following issue in PBI. I have data in column DTM which contains numeric and text values.  I need to count of DTM items which are in range 0 to 10, their Stat...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    You can create a measure like

    Num Open =
COUNTROWS (
    FILTER (
        'Table',
        VAR numVal =
            IFERROR ( VALUE ( 'Table'[DTM] ), BLANK () )
        RETURN
            numVal >= 0
                && numVal <= 10
                && 'Table'[Status] = "Open"
    )
)
johnt75's avatar
johnt75
Super User
4 years ago

You can create a measure like

Num Open =
COUNTROWS (
    FILTER (
        'Table',
        VAR numVal =
            IFERROR ( VALUE ( 'Table'[DTM] ), BLANK () )
        RETURN
            numVal >= 0
                && numVal <= 10
                && 'Table'[Status] = "Open"
    )
)