cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Calculate Min of Multiple column and measure

Hi Team,

I have one column consider "excess_aggregate"and two measure's   one is "Quality Excess Agreegate" and   another is "selling Price" in this i want to calculate the min of three it give's me error of A Circular dependicy please let me know any workaround to this problem.

1 ACCEPTED SOLUTION
Community Support

First, you should know that column is static but measure is dynamic

1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Therefore, measure value will changed with different row context.

and for your case, it looks like a max value in measure problem, please refer these two posts, they have the similar logic:

If you still have problem, please share a simple sample pbix file and your expected output.

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support

First, you should know that column is static but measure is dynamic

1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Therefore, measure value will changed with different row context.

and for your case, it looks like a max value in measure problem, please refer these two posts, they have the similar logic:

If you still have problem, please share a simple sample pbix file and your expected output.

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

That being said, check out MC Aggregations: https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...