Forum Discussion

areias_br's avatar
areias_br
Icon for Helper I rankHelper I
10 months ago
Solved

Filter Only some Collumns with Calculate

Hi, I have a measurement with the following Formula:   AcoesOverduePorDia = VAR DataReferencia = MAX('tb_calendario'[Data]) RETURN IF( DataReferencia <= TODAY(), CALCULATE( COUN...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    10 months ago

    Hi  areias_br, 

    Thank you for reaching out to the Microsoft fabric community forum. I tried out the scenario using your data from the community, and it worked for me. I just tweaked the Dax and the relationship, and everything went smoothly.

    Relationship:


    outcome:


    I am also including .pbix file for your better understanding, please have a look into it.

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

Shubham_rai955's avatar
Shubham_rai955
Icon for Super User rankSuper User
10 months ago

To allow your measure to respect filters on Task Owner and Action Type, while ignoring only the date filter from 'tb_calendario', you should remove only the date column filter— not the whole calendar table—so that other slicers from 'tb_calendario' (like month, year, etc.) will still work as usual.​

Revised Measure

 
AcoesOverduePorDia = VAR DataReferencia = MAX('tb_calendario'[Data]) RETURN IF( DataReferencia <= TODAY(), CALCULATE( COUNTROWS( FILTER( ALL('Tabela_Ações'), 'Tabela_Ações'[Data de Expiração] < DataReferencia && ( ISBLANK('Tabela_Ações'[Data de Fechamento]) || 'Tabela_Ações'[Data de Fechamento] > DataReferencia ) ) ), REMOVEFILTERS('tb_calendario'[Data]), KEEPFILTERS(VALUES('Tabela_Ações'[Task Owner])), KEEPFILTERS(VALUES('Tabela_Ações'[ActionType])) ) )

  • Change REMOVEFILTERS('tb_calendario') to REMOVEFILTERS('tb_calendario'[Data]) in the CALCULATE section.​

  • This ensures only the Date field filtering is removed, while other table filters are still applied.

This adjustment keeps your visual filters (including Task Owner, ActionType, and other calendar fields except date) working as expected.