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
    11 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.