Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Calculating cost based on average ticket count

Hello,   I need some help with calculating the cost of tickets per site.    A base rate of 100,000 for each agent (e.g. Alpha costs the company 100,000 to employ for the year, etc.) then take tha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

I suggest you to do some transformation on your Sample Data Ticket Count Per Year in Power Query Editor.

Use Unpivot function:

Data model:

Measure:

Measure = 
10000 / SUM('Ticket Count Per Year'[Value]) * CALCULATE(COUNT('Table'[Account]),ALL('Table'))

Result is as below.

 

Best Regards,
Rico Zhou

 

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