Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm using CALCULATE in a couple of calculated columns and they created a circular reference. I found the article explaining the prob and know I need to use ALLEXCEPT to eliminate the reference. The prob is that ALLEXCEPT is then breaking the filter I'm trying to use.
here are the orig steps i'm trying to take. If existing in a vacuum, both work fine:
Solved! Go to Solution.
Hi @crobaseball ,
It is because that the 2 filters conflict.You'd better use below expression:
LstYrMTDSales = CALCULATE(SUM('03- Raw Data View'[Sessions]),FILTER(ALL('03- Raw Data View'), '03- Raw Data View'[IsLastYrMonth] = "Yes"&&'03- Raw Data View'[Date]=MAX('03- Raw Data View'[Date])))
Or you could use below expression with "Allexcept":
LstYrMTDSales = CALCULATE(SUM('03- Raw Data View'[Sessions]), ALLEXCEPT('03- Raw Data View','03- Raw Data View'[Date],'03- Raw Data View'[IsLastYrMonth]))
Then add a slicer and choose '03- Raw Data View'[IsLastYrMonth]="Yes":
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @crobaseball ,
It is because that the 2 filters conflict.You'd better use below expression:
LstYrMTDSales = CALCULATE(SUM('03- Raw Data View'[Sessions]),FILTER(ALL('03- Raw Data View'), '03- Raw Data View'[IsLastYrMonth] = "Yes"&&'03- Raw Data View'[Date]=MAX('03- Raw Data View'[Date])))
Or you could use below expression with "Allexcept":
LstYrMTDSales = CALCULATE(SUM('03- Raw Data View'[Sessions]), ALLEXCEPT('03- Raw Data View','03- Raw Data View'[Date],'03- Raw Data View'[IsLastYrMonth]))
Then add a slicer and choose '03- Raw Data View'[IsLastYrMonth]="Yes":
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
What I realized is that I was doing a calculated column and should have been using a measure, which eliminates the circular reference.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |