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
11 months ago

Hi Ankita_Das ,

A measure is computed at query time ; it doesnt take into account row context. Therefore you are getting all rows even though you filter for a specific value. I would suggest you go for a calculated column. By using a calculated column in slicer, the filtered value will respect the row-context since a calculated column is computed at row level.
Based on your description, I tried replicating the scenario to get the result-

Attached file for reference.
If I  misunderstood anything, kindly provide more information about your data/data model as this could also be one of the reasons why the data is not getting filtered.

Thank You.
Let me know if that worked for you.

Ankita_Das's avatar
Ankita_Das
New Member
10 months ago

There is no way possible to create any calculated field based on the DOH measure's value. It's showing circular dependency on "column" even if there are no calculated column named column.