Visualization to show "All Other" based on filter

[wes-shen-poal]

Hi there,

I currently have a "Transporter" filter, and a Card visualisation showing average number of days selected Transporters leave their vehicles in the car yard (Average Dwell Time)

E.g. as per screenshot below, currently transporter "CDG" has an average dwell time of 4.55 days.

Can someone kindly guide me through how I can show the Average Dwell Time of All Other Transporters (i.e. all transporters but excluding the transporter selected in the filter) for the Card visualisation where I circled blue in the screenshot?

Thanks in advance for your help.

Wes

[v-qiuyu-msft]

Hi @wes-shen-poal,

You can take a look at this similar thread: Slicer reverse selection in chart . Depend on your real data, you need to modify the measures.

Best Regards,
Qiuyun Yu

[wes-shen-poal]

Hi @v-qiuyu-msft

Thanks so much for referring me to another post. I had a read and understood that the solution provided in that post did not take into account other slicers.

For my scenario, I also have four other slicers (two date ranges, Vehicle ID Classification, and Shipping Line). The Transporter slicer is the one I want to use as the reverse selection for my visualisation while still taking into account the four other slicers.

I did stumble across this article (http://www.skillslogic.com/blogdetail/98/power-bi-how-to-show-rows-excluded-by-slicer) where the author seemed to have captured the other slicers, but I don't know how to tweak the DAX formula so that it takes into acount the two date-range slicers I have.

Do you have any other ideas?

Thanks,
Wes