Make a result visual count the % that are filtered interactively on a visual

[Anonymous]

Hi there, 

The question might be a bit confusing but it's just a simple enquiry, I have a visual like this below:

This displays a % of a grand total of userid count. And I also have a mini card visual in the top right corner that says a 100% with the exact same column applied too it (with % of grand total)

However, I want the top right card visual to show and add up %'s when multiple bars are clicked on the report, such as below:

As you can see, the first 3 bars have been highlighted (clicked on), but the top right % is still 100%, I want it to show the total % highlighted which would be 27.63%. I figured with both visuals sharing the exact same value, it would automatically do this but it isn't. 

How would this be possible? And is it possible? 

[Anonymous · Accepted solution]

Hi guys, figured it out. I needed to filter the other category on the visual for it to work, however, blanks were also filtered out so I made sure to filter it with > 1 (categories were numerical) 

% Match =

DIVIDE ( [User Count], CALCULATE ( [User Count], ( Candidates[ap_imd_decile] > 0 ) ) )

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Anonymous]

Hi @Ashish_Mathur 

Thank you but unfortunately the file has too much confidential data and it would take a really long time to make a dummy file. Do you know of how to create a measure that can do this function that I request? 

[Anonymous]

Hi @Anonymous ,

Is the percentage value a measure?

If so you could create a new measure using SUMX() function and put it in the card visual.

Like:

SUMX(table,[percentage])

Best Regards,

Jay

[Anonymous]

Hi @Anonymous 

Yes on both visuals the value's are measures, I've tried that very measure you made and it's not working, the %'s aren't the same as the %'s on the graphic. 

So if I use this measure 

% match = SUMX(LadderProccess, [User Count] / 1000)

I put in the / 1000 to lose the 0's on the %, but it's still not working properly as shown below:

Do you know why that is?