What DAX measures can I use to create this?

[Anonymous]

I want to create something like this in power bi. How would I go about doing this?

[bhelou]

is that a table or what , if you can share some sample of the Pbix File , 

if u want as a measure try to divide : 

% of Total = Divide([YTD Product Sold],Calcualte(Sum([YTD Product Sold]),Allselected()))

[bhelou]

[Anonymous]

Hi, thanks for your response. But I am looking for a slightly different solution.

The data is actually a giant table with product information. What I need to do is create a table that I displayed in the original post.

Any thoughts sir?

[bhelou]

okay i think i got your question : 

try to make a new table with sumarized columns , attached pictures :  , 
in this you make a sammary of the table you have ( like grouping ) then you want to calculate the sum of the total inside it , then for the % use the measure provided in the first reply ) , hope this will help you , please accept as a solution it it works with you , 
if you have any trouble please share a sample of the PBIX file , 

[bhelou]

 the  summarized table is based on this table sample

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.
Table:

New Table = SUMMARIZE('Table','Table'[Item #],'Table'[Product],"YTD Product Sold",SUM('Table'[Sold]))

Column:

% of Total = DIVIDE([YTD Product Sold],SUM('New Table'[YTD Product Sold]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.