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
    )

     

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

Hi Anonymous 

You can add the date column and the country column inside ALLEXCEPT

Alternatively, you can use  

CALCULATE(COUNT(Table[Order]),REMOVEFILTERS(Table[Equipment]))