Forum Discussion
Using All Except in Combination with Multiple Slicers
Hi,
I am trying to get a count of unresolved items that can be derived as follows.
User selects Contract and the Filter Month.
Count would equal anything that is unresolved and created before the slicer date.
My problem is that the results page contains both trending data and this snapshot calculation so I can't just sync the slicer visuals between the menu and the results page. I have to ignore the date slicer somehow and have it lookup the user selected value to a date that I can use.
I have tried a few different measures using all except but can't seem to get the accurate count per contract per month and deal with the slicer/lookup date value issue.
Thanks!
3 Replies
Anonymous , if the ignore means that you need a trend before the date, you need independent date table
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] <=_max))If you need only value allexcept should work
Fact on "many" side and dim on one side
calculate([measure], allexcept(Fact, Date[Date]) )
Thanks, this is still not working as it would intended.
Isn't there a simple way to use just all or keep filters to do this? The box in step 1 is a text so this is making it more complicated.
I end up getting all of the contracts using a measure like this.
TEST COUNT = calculate(count('Detail INC Aging'[Number]),ALLEXCEPT('Detail INC Aging','Detail INC Aging [Contract]))I also don't seem to be able to take the selected slicer value and use that to filter on only that measure.TEST ALL = calculate(count('Detail INC Aging'[Number]),KEEPFILTERS('Detail INC Aging'[Contract]=[Selected Slicer Value Contract))
