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 
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

    Hi tamerj1 that's what I was looking for, thank you so much! 👍