Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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. -
Solved! Go to 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.
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.
@ahmedusam , Assume you are using measure M1 on visual
Then try a measure like
divide([M1], calculate([M1], allselected() ))
User | Count |
---|---|
57 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |