Add a Filter in a dax formula

[Anonymous]

Hi everyone, 

I have a DAX formula that is working ok, but i need to add a filter.

My actual DAX formula is:

Enabled  = CALCULATE((COUNTROWS('Peru - Registros y MAU GRUPO'),'Peru - Registros y MAU GRUPO'[Estado]="Enabled")

In the same table, i have a row with ages. I need to add in the previous formula the filter "less or equal than 30".

So the final result of the formula will only count the enable that has less or equal than 30.

Any body knows how??

thanks a lot!!

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Try

Enabled =
CALCULATE (
    COUNTROWS ( 'Peru - Registros y MAU GRUPO' ),
    'Peru - Registros y MAU GRUPO'[Estado] = "Enabled",
    'Peru - Registros y MAU GRUPO'[Ages] <= 30
)

[Anonymous]

Thanks a lot!!!!!