Exclude not working

[jerry_ile]

Real simple but hard for me for some reason

I have a combo chart and want to always show the Po Qty but the Sold Qty to change according to the Host selection

dimension

Start Wk

Measures 

Sum([Sold Qty])

Sum({<Host = >} AllPOQty)

for some reason when I select a host the 'AllPoQty' line goes to 0 instead of keeping the same values and ignoring the selection 

if I use {1} but takes PO's back to 2016 and 0's the sold Qty, I only want to ignore Host selection

[dplr-rn · Accepted solution]

seems weird.

can you replicate in a sample app and share ?

[jerry_ile · Accepted solution]

in replicating I saw the mistake, it was my own fault I had made a master dimension with the same 'Host' name, that was interfering with the formula

Thanks for the suggestion

[dplr-rn]

Good to hear