Forum Discussion
Calculation on Measure Totals
- 5 years ago
Hi, egsiegel
According to your description and example, I can understand roughly your logic and the output you want to get, you can try this measure to replace the calculated column I created before to calculate the percent:
To test the function of this measure, I changed the sample data to make them within the same date, like this:
agent percetage1 = var _valueofCall= CALCULATE(SUM(Merge1[Count]),FILTER(ALL(Merge1),[skill]="Call"&&[AgentName]=MAX('Merge1'[AgentName]))) var _valueofEmail= CALCULATE(SUM(Merge1[Count]),FILTER(ALL(Merge1),[skill]="Email"&&[AgentName]=MAX('Merge1'[AgentName]))) var _valueoflogintime= CALCULATE(SUM(Merge1[Table (2).Logintime]),FILTER(ALL(Merge1),[AgentName]=MAX('Merge1'[AgentName]))) return DIVIDE(_valueofCall*5+_valueofEmail*8,_valueoflogintime)Then you can create a table chart and place it like this:
And I guess this can be what you want.
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you...that looks like what I am looking for....I will give it a shot