Harvesting multiple Slicers

Anonymous — Thu, 10 Dec 2020 21:01:55 GMT

For a scorecard, I need to weigh some categories based on importance. Said weights must be selectable from a filter based on their category (categories might have different weights).

I created a table with the weights with the percentages to multiply against and created the below:

CAT3 Selection

(((sum(Query1[CAT3 Error]))=blank()),blank(), if(HASONEVALUE('Weighted Percents'[CAT3 Weight]),Values('Weighted Percents'[CAT3 Weight]),0))

CAT4 Selection

IF(((sum(Query1[CAT4 Error]))=blank()),blank(), if(HASONEVALUE('Weighted Percents'[CAT4 Weight]),Values('Weighted Percents'[CAT4 Weight]),0))

cat3 Weighted Scenario

([cat3 Selection]*1)*sum(Query1[cat3 Error])

cat4 Weighted Scenario

([cat4 Selection]*1)*sum(Query1[cat4 Error])

My problem is this: When I select a slicer, it works, but it also automatically selects the same value on the other slicer. If I edit the interactions between the two slicers, I get a value of 0 in the data unless they are the same. How can I fix this?

Re: Harvesting multiple Slicers

daxer-almighty — Sun, 13 Dec 2020 09:41:24 GMT

Slicers must be independent. You can't use one table and one column for many slicers and expect that when you filter one slicer the other will not be filtered. It does not work like that.

topic Harvesting multiple Slicers in DAX Commands and Tips

Harvesting multiple Slicers

Re: Harvesting multiple Slicers