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
    )

     

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?