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
Sample source data please. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
