Forum Discussion
sum of 20%
Community ChampionTough to say. 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
But generally you would want something like:
% of Total = DIVIDE([sales of 20%],SUMX(ALL('Table'),[Sales]),0)
Hi Thanks Greg_Deckler , But thats also giving me 100. My data is looking something like this with the measure I provided in post:
Cluster Product % of total mkt sales Top 20% sales MA Prod 1 15.54% 491,278 MA Prod 2 11.36% 359,314 MA Prod 3 8.15% 257,596 MA Prod 4 6.69% 211,559 MA Prod 5 6.53% 206,382 MA Prod 6 6.14% 194116 100% 50,000,000 Market sales: 3.2 million
total regional sales: 50M
MX sales contr of top 20% products to regional sales : 1,720,245/50m = 3.4% >> I would like to show this result in the card.
Also, in the table I m seeing the regional sales in the total instead of the market total sales and in the % column I'm seeing the sales as % of the market sales (3.2m) but in total it is showing 100% (when in fact it is around 54%)
- Greg_Deckler
Right, again, 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
Sample source data, otherwise it's just pure guessing and likely going to be wrong.
Have you looked at the drop down for the column and the "Show value as" and then Percent of Grand Total?
See the attached PBIX that provides a DAX solution as well as the Show As method.
v-juanli-msftCommunity Support
Hi Anonymous
I don't kwow how to define the top20% product?
It is defined by "market sales" or "top20% sales"?
You could show some short raw data for me to test.
Best Regards
Maggie