How to get individual values in clustered column chart

[Praj]

Hi Everyone,

I have been stuck with a problem where I need to identify the individual values of a column and stack that together in a column bar chart. 

For example, I have below survey Q&A data and I need to find the individual contributions of each country and then put that value in the bar chart.

The output above gives me the overall contributions of each countries, however if I select any individual country(for ex, if i select France, I get the below values where approx, 23% have choosen option 1, 25% have choosen option 2 and 3 and 13% have choosen option 4 and 5)

I am looking to have the above same values when I deselect France from the filter in comparasion with other countries. I know the value gets divided by overall respondents if i clear filteres but is there any way on how I can get individual values of each countries together.

I have attached the .pbix file for reference in the below shared link. Any solution/approach is highly appreciated. 

https://drive.google.com/drive/folders/1SoUdJDzWLtrFCvDhNmaB04LiXNMxCXyJ?usp=share_link

Cheers,

Praj

[tamerj1 · Accepted solution]

Hi @Praj 
Please refer to your sample file updated as requested.

CountQ123 = 
VAR Count1 = DISTINCTCOUNT ( 'Q1,Q2,Q3'[Index] )
VAR TotalCount = CALCULATE ( DISTINCTCOUNT ( 'Q1,Q2,Q3'[Index] ), ALLEXCEPT ( 'Q1,Q2,Q3', 'Q1,Q2,Q3'[Country] ) )
RETURN
    DIVIDE ( Count1, TotalCount )

[Praj]

Hi @tamerj1 ,

Thanks for the approach. The solution worked.

Cheers,

Praj