Forum Discussion

zivhimmel's avatar
zivhimmel
Resolver I
5 years ago
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...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    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