Forum Discussion
Solved
Calculated Column
I'm struggling to performa required calc, which I want to do in a new column. Example Data: Table: Monthly_Sales Consultant Month Sales Best Month % Best A...
Try This:
Best NEW = VAR BEST = CALCULATE( MAX(SALES[Sales]),ALLEXCEPT(SALES,SALES[Consultant])) RETURN BEST% vs BEST = DIVIDE( SALES[Sales], SALES[Best NEW] )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
FrankS72 , try like
divide(sum(Table[sales]),calculate(max(Table[Sales]), allexcept(Table, Table[Consultant])))
Also, refer
https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390