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.

v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
10 months ago

Hi areias_br,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Shubham_rai955, rohit1991, kushanNa, for those inputs on this thread.

Has your issue been resolved? If the response provided by the community member Shubham_rai955, rohit1991, kushanNa, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.


If the issue is not resolved, Could you please provide sample data illustrating the issue and the expected outcome? This will help us efficiently reproduce the scenario and assist you accordingly.

Thank you for using the Microsoft Fabric Community Forum.