topic Re: Change percentage of a card based on 2 visualization in DAX Commands and Tips

Change percentage of a card based on 2 visualization

ahmedusam — Tue, 15 Feb 2022 04:27:41 GMT

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. -

Re: Change percentage of a card based on 2 visualization

amitchandak — Tue, 15 Feb 2022 04:43:40 GMT

ahmedusam , Assume you are using measure M1 on visual

Then try a measure like

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

Re: Change percentage of a card based on 2 visualization

V-lianl-msft — Fri, 18 Feb 2022 06:02:57 GMT

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-p/963216

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