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,
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