Table with calculated expression no longer filters to selections

[Anonymous]

Hi all - probably one of those easy questions to find the answer for if you know exactly what to ask, but I can't so here goes

I have a Straight Table as below (Company units are blanked).   The June and July numbers are calculated expressions as

Sum ({<Month={"Jun"}>}[Sales])

Sum ({<Month={"Jul"}>}[Sales])

With the spark line expression

sum([Sales])

When I making any Business Unit selections anywhere such as a list box, the graph doesn't change to filter down to the BU selected.   The Sparklines will disappear for all lines except the BU selected, but the remainder of the graph remains static as below

How do I program these expressions so they still filter if a user makes a BU drill down selection ?

[Anonymous]

The tables filters fine with no change to the expressions as long as the table's Alt State is set to <Default State>

Setting it to any other Alt State else means it won't filter any expression with a condition in it (eg. Sum ({<Month={"Jul"}>}[Sales]) but will any expression with no condition (eg. sum([Sales])  )

[sunny_talwar]

Not sure if this will make any difference, but try this:

Sum({StateName<Month={"Jun"}>} [Sales])

Sum({StateName<Month={"Jul"}>} [Sales])