Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add a Filter in a dax formula

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 MA...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    Try

     

    Enabled =
CALCULATE (
    COUNTROWS ( 'Peru - Registros y MAU GRUPO' ),
    'Peru - Registros y MAU GRUPO'[Estado] = "Enabled",
    'Peru - Registros y MAU GRUPO'[Ages] <= 30
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Thanks a lot!!!!!