Dividing rows

Question

Hi All,&nbsp;Table is set up like this.&nbsp;measure 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; measure 2&nbsp;&nbsp;&nbsp;&nbsp; year 1&nbsp;&nbsp;&nbsp; year 2&nbsp;&nbsp;&nbsp; year 3Flower&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1Flower&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lily&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 6Flower &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; aster &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4Trees &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8Flower &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; coconut &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0Flower &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; mango&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9 &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp;Now I want to divide the total sum of Flower with regards to trees sum(flower)/sum(trees) such that the table will show&nbsp;measure 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year 1&nbsp;&nbsp;&nbsp; year 2&nbsp;&nbsp;&nbsp; year 3Flower/trees&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;how do I create a dax measure to divide rows?&nbsp;Thank you!&nbsp;Kind Regards,&nbsp;

greg_deckler · Accepted Answer

You should unpivot your year columns.&nbsp;Then you can do something like this:&nbsp;Flowers/trees = CALCULATE(SUM('FlowersTrees'[Value]),'FlowersTrees'[Measure1]="Flower")/ CALCULATE(SUM('FlowersTrees'[Value]),'FlowersTrees'[Measure1]="Trees")I do not get the numbers that you presented in your solution though from the data you provided.

Forum Discussion

Dividing rows

1 Reply

Related content

Dax Help- Average or divide by Row

Divide rows by specific total row

Divide in Power BI

Divide each row value with total row total

Subtotal Divided by Row Value