100% Stacked Column Chart with measure and parameter field

[ASuhaji]

Hello Everyone,

I need help because I can't figure out the solution.

I have a stacked column chart and I would like to transform it to a 100% stacked column chart using measure.
This is the simple measure that works:

# Sales = SUM('Data'[Products sold])

% Sales = DIVIDE([# Sales], CALCULATE([# Sales], ALL('Data'[Posting Type])))

[Posting Type] is a field which I use as a legend among others because it is a selected value from a field parameter.

So the measure above perfectly works if the "Posting Type" is selected but if I change it to another value, the calculation will understandably not be good (the 'Data'[Posting Type] expression should change dynamically).

Could you help me find a solution to this problem?

Thank you in advance.

[v-jingzhang]

Hi @ASuhaji 

Can you provide some sample data? How does "Posting Type"/"Procurement Type"/"Partnership Type" show in the underlying data table? Are they from the same table? And what is the current result when you select other values except "Posting Type"? 

Best Regards,
Community Support Team _ Jing