Forum Discussion
divison calculation for the same column
Each dealer has four types of contracts they can sell. grouped as OL/CH and HP/FL I need to calc the percentage of all their deals which are OL/CH and HP/FL How can this be done? Other colu...
CH/OL% = DIVIDE(SUM('Key Measures'[CH/OL],SUM('Key Measures'[CH/OL])+SUM('Key Measures'[1 HP/FL]),0))
Why does this calculation not work for me? it wont pick up the table that the columns are in
also this message comes up
Too many arguments were passed to the SUM function. The maximum argument count for the function is 1.
Hi Anonymous ,
Sorry, not very clear, can you provide me with pbix file? Remember to hide private data.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.