topic Re: Use the total from a measure to divide another measure in DAX Commands and Tips

Use the total from a measure to divide another measure

Anonymous — Mon, 24 Feb 2020 13:07:17 GMT

HI,

I am trying to figure out how to use a measures total to then use the measurere to get a percentage of that to tal. For exaple a have a measure of: Reason = count(returned[sku]) This gives me the correct number for the returnmed skus and their respective reasons. Now i need to get a percentage of the measure for the total. Ignore the overall% Refund.

Now is it possible to use the measure to either create a column with the values of 382 (this is an auto update when more enteries are added). I could then divide the column by the measure. I need to get a persentage of the refund reason count for each so working out on a clculator 382/155 = 40.57% then 48/382 = 12.56% and so on.

Thanks in advance

Re: Use the total from a measure to divide another measure

Greg_Deckler — Mon, 24 Feb 2020 13:11:52 GMT

Having a bit of a hard time following this. 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

Re: Use the total from a measure to divide another measure

Anonymous — Mon, 24 Feb 2020 14:42:10 GMT

Sorry if it wasnt clear.

I have created a measure to sum the amount of returns i have for each reason. This has a total at the bottom. I then want to use the grand total of 382 from the measure to create a percentage measure.

So i have got each reason to show how many products have come back thats the first column

I want in another column to get the percentage of the grand total.

In essance i want to use the grand total for from the first measure to create a second measure where i can divide the grand total of the first measure by the values of each reason to create a percentage.

Thanks

Re: Use the total from a measure to divide another measure

vivran22 — Tue, 25 Feb 2020 10:30:53 GMT

Hello Anonymous ,

You may try:

% to total = VAR _CountRows = COUNTROWS(dtTable) VAR _TotalRows = CALCULATE(COUNTROWS(dtTable),ALL(dtTable)) Return DIVIDE(_CountRows,_TotalRows)

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn