Measure to define target market share

[jakubkola]

Hi all,

i would appreciate if someone could point me into the right direction with how to achieve the below:

i have a simple market share measure in a bar chart:

=sum([QTY]) / sum(TOTAL {<supplier>} [QTY])

which gives me a market share based on qty of purchased items in a certain time bracket.

I would like to add another bar right next to it with a measure describing  min target % - this comes from another table which looks like that:

supplier / category / ms% min / ms% max

supplier1 / category a / 60% / 100%
supplier1 / category b / 11% / 20%
supplier2 / category a / 11% / 20%

what would be the best way to achieve this?

[Qrishna]

Some sample data please?