Forum Discussion
Helper IIDAX - Not apply certain slicers
Hi,
I have the following slicers and a card. I would like that only the slicer team applies to the card and not the quarter, the month and the year slicer. I would like to do it through a measure and not through edit interactions". How can I achieve this through DAX? Thank you so much!
Are the qtr, year and date coming from a date table (or a table that is separate from the teams table)?
If so then you can try something like:Sales = CALCULATE(...[your Sales Measure], REMOVEFILTERS(DateTable))Otherwise, you can look into filter arguments such as ALLEXCEPT(Table, Table[Team])) , or ALL()
1 Reply
vicky_Super User
Are the qtr, year and date coming from a date table (or a table that is separate from the teams table)?
If so then you can try something like:Sales = CALCULATE(...[your Sales Measure], REMOVEFILTERS(DateTable))Otherwise, you can look into filter arguments such as ALLEXCEPT(Table, Table[Team])) , or ALL()