Forum Discussion

vbourbeau's avatar
vbourbeau
Icon for Resolver II rankResolver II
7 years ago
Solved

ALLEXCEPT allow filter not explicitly add in the ALLEXCEPT

Hi,   Please help I'm on it since few day.   I don't understand I put a DAX request with ALLEXCEPT function and when I add a date column (yeah other column work) on the exception all other filter...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, vbourbeau

    You could try this way as below:

    step1:

    Create a date table and then create a relationship with basic data table.

    use ALL() Function in your formula like this

    Measure = CALCULATE(SUM(data[Hrs]),ALL(data[Client],data[Quart],data[Quart day]))

    Add the fields that will be dragged into slicer into ALL() conditional.

     

    Result:

     

    Best Regards,

    Lin

     

     

vbourbeau's avatar
vbourbeau
Icon for Resolver II rankResolver II
7 years ago

Hi,

 

I can't use the interactions because I want to use this mesure in a calculation as denominator. 

Look the above pbix it's a simple one and the behavior occur.

 

Play with each filter and see the measure change even if I use Allexcept. Only the date must affect .

 

https://we.tl/t-m4REX9QCnw

 

I don't find where I can attatch a file to the post? I put a wetransfer link but it will not stay long there...

 

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, vbourbeau

You could try this way as below:

step1:

Create a date table and then create a relationship with basic data table.

use ALL() Function in your formula like this

Measure = CALCULATE(SUM(data[Hrs]),ALL(data[Client],data[Quart],data[Quart day]))

Add the fields that will be dragged into slicer into ALL() conditional.

 

Result:

 

Best Regards,

Lin

 

 

  • vbourbeau's avatar
    vbourbeau
    Icon for Resolver II rankResolver II
    7 years ago

    It's working but I don't understand why we need to create an other table?