Forum Discussion
vbourbeau
Resolver II
Resolver IIALLEXCEPT 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...
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
v-lili6-msft
Community Support
Community Supporthi, 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
vbourbeauResolver II
Resolver IIIt's working but I don't understand why we need to create an other table?