Chart - Percentages of Selected Group

[RHamilton]

Hello PBI Community, 

Im a bit stuck on configuring percentages. 🤔 and have spent hours trying to figure it out. 😑

I have a simple matrix and when I click on a row, I would like to show the percentage of the ROW. 

By defaut, PBI gives a percentage of the whole group as shown below

Here in the first image the counts are correct  (simple count measure) but the percentages are of the whole dataset

I would expect here

34/160 = 21%

126/160 = 79%

So I created a divide measure...and now the percentages are correct but how do I get the correct counts to show?

Many Thanks in advance!  I hope this helps others also.

[JosefPrakljacic]

Hey @RHamilton,

may I ask you to post a short demo data table?

BR,

Josef

[RHamilton]

Hello @JosefPrakljacic 

Thanks for your reply. See the image. Hopefully you'll get the idea? 

There is a row per department.

[v-xuding-msft]

Hi @RHamilton ,

Can you please share the sample data table not the matrix?  And Please share the formulas that you tried. Then we will understand clearly.

Here is my sample. Maybe you could reference it to have a  try firstly.

%Government = 
var Government = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Segment] = "Government"))
var Total = CALCULATE(SUM('Table'[Sales]),ALLSELECTED('Table'))
return
DIVIDE(Government,Total)

[RHamilton]

Hi @v-xuding-msft ,

Many thanks for your reply.

Sorry, I do not see a way to upload/attached a file other than an image. 

Based on your response, I think maybe the only way to accomplish what I need to create a summary table of my larger table and then take the same approach as you did below. Unless there is a better way using the dataset as I have provided without any intermediary summary steps?

Here is what my data looks like, again sorry but I do not see a way to upload the actual Excel file.

[JosefPrakljacic · Accepted solution]

Hey @RHamilton,

If I have understood you right, you just need to edit the interactions to achieve your desired result.

Here's the Screenshot

Here's my File

https://1drv.ms/u/s!AsLz0i2VASN1oJwcDFQf7oN87ZtPpw?e=2GK8ge

[RHamilton]

@JosefPrakljacic , Thank you!  👍 Wow....something so simple and small - so hidden away on the top of the chart. It just says 'filter'. Oh well, not even sure what it means in the context of the interaction but it worked. I'll look it up later.

You've really made my day!

Best Wishes, 😁