Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

dax - circular reference error with two measures using same filter

Hi All,   I am trying to create slicers based of sales quantity (no sales) over time. I can create the first measure which works well however if I create a second one with a different date filter I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

You can refer the method in the following links to resolve the problem of circular reference error. If they can't help you resolve the problem, please share with us about the sample data in fact able and the related formula of column [0-12 MonthsFlag] &[6-12 MonthsFlag] in order to provide you a suitable solution.

Circular reference error

Avoiding circular dependency errors in DAX

Best Regards