Forum Discussion
MMatthews
5 years agoRegular Visitor
Percentage Total?
I have a problem. The monthly total is right per Tech, but the Total for all techs is wrong. The Sum is correct on the Month by month. the Average is right a the Total. How do I get the Total?
MMatthews , Change the measure like and try
overhead = sumx('Tech Hours', 'Tech Hours'[Total Paid hours]*'Tech Hours'[Cost])*1.5
4 Replies
- amitchandakSuper User
MMatthews , can you share the measure/formula?
- MMatthewsRegular Visitor
These are Measures.
- amitchandakSuper User
MMatthews , Change the measure like and try
overhead = sumx('Tech Hours', 'Tech Hours'[Total Paid hours]*'Tech Hours'[Cost])*1.5
- MMatthewsRegular Visitor
Your the man.