Forum Discussion

Ankita_Das's avatar
Ankita_Das
New Member
11 months ago
Solved

How to filter columns in a visual Rows by measures?

Hello Community, I have a Power BI report where measures are calculated for each week of the year (up to W52). Using these weekly measures, I developed another measure called DOH (Days on Hand). No...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    10 months ago

    Hi,
    Circular dependencies occur when a measure or calculated column referencing a field that is itself dependent on another calculated field.

    Sorting or filtering a column based on another calculated column also causes cicular dependencies.
    Try to :

     

    1.Use RemoveFilters or ALLEXCEPT : These can help isolate dependencies.

    2.Ensure no bidirectional relationships are causing loops.

    Additionally, I would encourage you to share your DAX measure or share your sample data excluding sensitive data.
    Thank You

     

     

     

v-sdhruv's avatar
v-sdhruv
Community Support
10 months ago

Hi Ankita_Das ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions, please feel free to reach out.We would be  happy to help with any further assistance you may need.

Thank You