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.

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

Hi,
it didn't work also.

 

Below you see the graph of the measure per week. It allows me to see if I'm improving or not related to treating overdue actions. It's a picture of that week, so, even if a action expires in week 36, but it was closed on week 39, it will count as overdue in week 36, 37 and 38.

However, I need the graph to react to the filters from the collumns: Task Owner and Action Type. But none of the formulas i've tried works, it always also change the calendar filter and them becomes a mess.