Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic ALLEXCEPT based on selected slicers.

I have a measure with ALLEXCEPT DAX command for count the quantity of orders per equipment category. But it is static, but in order to have a real count depending of the selection in the slicers in n...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    This should work

    Quantity of orders per Category = 
VAR SelectedDates = ALLSELECTED ( 'Table'[Date] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ), 
        REMOVEFILTERS ( ),
        VALUES ( 'Table'[Category] ),
        SelectedDates
    )

     

littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous the reason it's not changing is because ALLEXCEPT() only includes Category as a field to ignore filters.

 

But I'm thinking you might be overcomplicating this...have you tried just simply COUNT(Table[Order]) as your measure?  That would take into account filter context for Category, Date, Country, or whatever other filters are applied.  If you did, what happened?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for your answer littlemojopuppy 
    If I just make a simply COUNT(Table[Order]), the measure is going to count the amount of orders by equipment but not by category. In the example the table is going to be something like:


    Category: Trucks Quantity of orders per Category: 10
    Truck 14
    Truck 22
    Truck 31
    Truck 43
    Category: MixersQuantity of orders per Category: 15
    Mixer 19
    Mixer 26

     

    Thanks

    • littlemojopuppy's avatar
      littlemojopuppy
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous can you provide some sample data to work with?