Change percentage of a card based on 2 visualization

[ahmedusam]

Hey,

So I have this created.

1. When I click the bar chart, I want the percentage on the card to be based on the data in the bar chart. For example, when i click completed from the bar chart, i want the card to show percentage of audits completed during the year.

2. Then, I want the same card to change percentage when i click random items from the table below based on the percentage each task has completed. - 

[V-lianl-msft · Accepted solution]

Hi @ahmedusam ,

Please try to create a measure like below:

Measure =
var one_year = CALCULATE(SUM(financials[ Sales]),FILTER(financials,YEAR(financials[Date])=2020))
return DIVIDE(SUM(financials[ Sales]),one_year)

If the problem still exists, please remove the sensitive data and share a sample pbix.https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ahmedusam , Assume you are using measure M1 on visual

Then try a measure like

divide([M1], calculate([M1], allselected() ))