Displaying the total column percentage instead of the grand total percentage with legends/multiples

[jesperlkjaer]

Hi all!

I have spent hours searching for this, but none of the DAX commands seem to be working for me. I am trying to show a chart which would display the satisfaction scores from 0-10 (categorical, not continuous) by country (either using a legend or small multiple). However, whenever I do it, it counts the grand total and not the column total. It is possible to change this with a matrix, but I would prefer it to be a chart. 

I tried this measure, but it gives me all sorts of trouble and errors: 

Percent of Total =

DIVIDE (

    COUNTA(),

    CALCULATE), ALLEXCEPT (]) )

)

I have made the following variables:

- ID (unique)

- Country 

- Satisfaction score

- Recommendation score

I have linked to a file I have made with some random data: https://we.tl/t-KrxCKbkyn1

Hope someone can help!

[amitchandak]

@jesperlkjaer , Refer if this can help

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s