Creating DAX measure from excel worksheet

Question

&nbsp;I have 3 tables:*Fruit-Ordered**Fruit-Sold**Fruit+Ordered*&nbsp;&nbsp;I've brought this data in from Excel but I need to be able to create a measure in Power BI to create "Percentage" for the&nbsp;Total&nbsp;&amp; also the "percentage" for the&nbsp;Products&nbsp;as well.&nbsp;"Percentage Total"&nbsp;&nbsp;&nbsp;"Percentage OF TOTAL"&nbsp;&nbsp;I've already have a measure for the total of "Sold+Ordered" but having the issues with using "VAR" or "FILTERS" to create the measures for "PERCENTAGE OF THE TOTAL"&nbsp;Any HELP would be awesome, I didn't explain this correctly the first time so hopefully I can get some answer.Thank everyone&nbsp;&nbsp;&nbsp;

shaurya · Accepted Answer

Hi&nbsp;SteelChampzz,&nbsp;You can use the following DAX formulas:&nbsp;% = 'Table'[Amount]/SUM('Table'[Amount])&nbsp;Index = RANKX('Table','Table'[Product],,ASC)&nbsp;Total = SUMX('Table', IF('Table'[Index]&lt;=EARLIER('Table'[Index]),'Table'[%],0))&nbsp;Result:&nbsp;&nbsp;Works for you? Mark this post as a solution if it does!

Forum Discussion

Related content

Help to create DAX Measure

Need help creating a measure

Lock worksheet

Need help combining two worksheets

Need help combining 4 worksheets into one