How to calculate percentage for selected columns

[MartinHab]

Hi guys,

I'd like to calculate percentage for selection in chart (in this case pareto, not sure if it changes something). I have one card which shows me Total of values in these columns and I'd like to have another card next to it which shows percentage of grand total (i.e. I am showing now 888 items of 3888 so I'd like to have % card next to 888 card).

Please advise.

Kind regards,

Martin

[Anonymous]

Hi, @MartinHab 

Thanks for Uzi2019's reply. May I ask if you have currently resolved this issue? If not, like he said, you can share the pbix file without sensitive data for testing. Feel free to help you.

Best Regards,
Yang
Community Support Team

[Uzi2019]

hi @MartinHab 

can you share the sample data nd screenshot of your expected output to depict your story?? like based on sleection of chart you column is calculted???

[MartinHab]

Hi @Uzi2019 

I am sorry, connot share data but please find screenshots below:

Without selection

Selection

[Uzi2019]

Hi @MartinHab 

I am not asking for any real or actual data. i am asking for sample data just try to create something similar to your data and share that with us.  bcz without proper understanding of your level of your data cant suggest anything..

can you write down along with screenshot where you want to calculae and how ??