Disconnect Table for slicing a measure

[valgecko]

Hello,

I've read and watched a lot a videos on how to do that but my context is a little different. I want to be able to extract or not a condition, created by a measure.

I have a measure Qty Forecast. I want to be able to extract or not qty 0 or empty. To do so, I have created a measure 

1. 

2. I have created a disconnect table

3. I have started my main measure in ordre to be able to link my slicer with desired condition. 

The selection works just fine when I put this last measure into a card et use the table created as a slicer

Now my challenge is to be able to filter (extract) one of the result of my measure from my visual with a slicer, condition 1. I am not able to conclude my measure. Doesn't work. Anyone know?

I am trying to do something like that but not selection a different measure but selection a result of a meau

[mahoneypat]

Since you just have two conditions (1 or 0), I would just use an IF but you can just have something like this in the Return part of your measure to return either of two expressions.

Return IF(selection=1, SUM(Table[Column1]), CALCULATE(SUM(Table[Column1]), Table[Column2] = "Some Value"))

Regards,

Pat