How to force a Power Pivot slicer to show a specific segmentation

[Anonymous]

Hello experts,

I have the following situation:

One of my slicers called version has two options: 

a) Base Version

b) Weekly Supply Version

The key figure 1 only shows value when the Base Version is selected, but I would like to show the same values when Weekly Supply Version is selected. In other words, whatever info is showed when filtered Base Version, also shows in "Weekly  Supply Version", not too sure how to copy from Base Version to Supply Version.

Cheers,

Gilly

[Anonymous]

Hi,

in your Dax queries use function FILTER, EXCEPT, EXCEPTALL.

YOU WILL GET YOUR DESIRE RESULT BY USING THESE FUNCTION