Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm struggling to figure this one out.
I have the following DAX formula that gives me the top 10 publications based on the average number of calls answered per day;
Top 10 All Calls = CALCULATE ( [Total Calls Answered] ,TOPN(10 ,FILTER ( SUMMARIZE( CTIPublication, CTIPublication[Publication], "AvgCalls",AVERAGEX( CTIPublication, CALCULATE ( SUM ( CTIPublication[Answered])- SUM( CTIPublication[Total Calls Transferred]))), "Quotes", SUMX (CTIPublication, CALCULATE ( SUM ( CTIPublication[Quotes]))), "AnsLessTrans", SUMX ( CTIPublication, CALCULATE( SUM (CTIPublication[Answered]))) - SUMX ( CTIPublication, CALCULATE ( SUM (CTIPublication[Total Calls Transferred])))) ,[AvgCalls] > 20), DIVIDE ( [Quotes] , [AnsLessTrans] ), DESC))
For the entire period on my report this is 32,117.
I want a donut chart that shows the total number of calls answered which is 98,369 with the top 10 total above as a proportion of the total, so visually you can see how much of all the calls answered the top 10 makes up.
It needs to remain dynamic though so when a user selects an item from the table or changes the date selection in the filter the donut chart proportions change in line with the selections.
Haylp!
Hi @phteven79,
Based on my understanding, you can get the total answered first, then calculate the proportion of total using the formulas below.
Total answered=SUMX(ALL(CTIPublication),CTIPublication[Answered]) percentage=[Top 10 All Calls]/[Total answered]
>>It needs to remain dynamic though so when a user selects an item from the table or changes the date selection in the filter the donut chart proportions change in line with the selections.
Without your sample table, I can't reproduce your scenario. There are two slicers in your report? Could you please share your .pbix file for further analysis? So that we can post solution which is close to your requirement.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |