Finding a constant total of selected Market

[Anonymous]

I have a Dim Table with Markets and Products

I need to find the market share of a product within the slected Markets. 

In order to do that, I need to keep the total of the slecetd markets as constant irrespective of the the selected products within the seleceted market.

Generally it works. But when I unselect a produt where there is only ONE product in one of the market, the Market also get unslected and the total gets changed.

How can I keep the selecetion of the Market undisturbed irrespective of the slection of the product.

[mahoneypat · Accepted solution]

Not totally clear on your scenario but you can use ALL or ALLSELECTED to get a total of the products within the market.  You can use that for your expression or in a variable on your way to your result.

All Markets = CALCULATE([Your Measure], ALL(Table[Product]))

Regards,

Pat