Forum Discussion

ukare1996's avatar
ukare1996
Icon for Helper I rankHelper I
3 years ago
Solved

CALCULATE FILTER Not working

Hi, can someone please help me understand why my query is not working as it should be? I am trying to Count number of rows where the field is not equal to "None" and Blanks are not counted in. The qu...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi ukare1996 

    try like:

    Measure = 
COUNTROWS (
    FILTER (
        'Network protection',
        'Network protection'[Monitor 1]<>"None"
            && 'Network protection'[Monitor 1] <> BLANK() 
    )
)

     

    verified with a simplified dataset:

     

    it worked like:

     

    if you prefer CALCULATE, try like:

    Monitor 1 - Action taken by customer = 
CALCULATE(
    COUNT('Network protection'[Monitor 1]),
    FILTER(
        'Network protection', 
        AND(
            'Network protection'[Monitor 1] <> "None", 
            'Network protection' [Monitor 1] <>BLANK()
        )
    )
)

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi ukare1996 

try like:

Measure = 
COUNTROWS (
    FILTER (
        'Network protection',
        'Network protection'[Monitor 1]<>"None"
            && 'Network protection'[Monitor 1] <> BLANK() 
    )
)

 

verified with a simplified dataset:

 

it worked like:

 

if you prefer CALCULATE, try like:

Monitor 1 - Action taken by customer = 
CALCULATE(
    COUNT('Network protection'[Monitor 1]),
    FILTER(
        'Network protection', 
        AND(
            'Network protection'[Monitor 1] <> "None", 
            'Network protection' [Monitor 1] <>BLANK()
        )
    )
)

 

ukare1996's avatar
ukare1996
Icon for Helper I rankHelper I
3 years ago

This worked - thank you so much 🙂