Forum Discussion
Solved
ALLEXCEPT help needed
Hi, I'm trying to use Allexcept with a column on a dimension table and it looks to be ignored. Let's say I have a sales fact table. Every record is for a sale and there's a customer satisfacion sco...
Hi zivhimmel ,
Would you please try to use the following measure:
avg_satisfaction_Same_city= CALCULATE(AVERAGE('Fact Sale'[satisfaction]),ALLEXCEPT('Dim Customer','Dim Csutomer'[City]))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi zivhimmel ,
Would you please try to use the following measure:
avg_satisfaction_Same_city= CALCULATE(AVERAGE('Fact Sale'[satisfaction]),ALLEXCEPT('Dim Customer','Dim Csutomer'[City]))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai