Forum Discussion
Solved
Keep filter - TopN Sales Contribution %
Hi every one, I try Topn Sales with "Sub-Cat" wise contribution %. Here i need to show my percentage values with TopN sales by elimating unwanted data. Contribution % formula is: GT% Val...
Hi venug20,
Update your formula as below.
GT% Values = IF(ISBLANK([TopN subcate]),BLANK(), [total sales]/CALCULATE(SUM(Orders[Sales]),ALLSELECTED(Orders[Sub-Category])))
Alsp please find the pbix as attached.
Regards,
Frank
Hi venug20,
Update your formula as below.
GT% Values = IF(ISBLANK([TopN subcate]),BLANK(), [total sales]/CALCULATE(SUM(Orders[Sales]),ALLSELECTED(Orders[Sub-Category])))
Alsp please find the pbix as attached.
Regards,
Frank
