Forum Discussion
Solved
How to divide two different rows in a table
Hello everybody! I´m bogged, trying to solve a simple problem. I have a "Sales" table with info such as this: Order SKU Quantity 1 Banana 10 1 Apple 5 2 Banana 10 2 Appl...
Measure 1:
GT Apples = CALCULATE( SUM( 'Sales'[Quantity] ) , 'Sales'[SKU] = "Apples" )
Measure 2:
GT Bananas = CALCULATE( SUM( 'Sales'[Quantity] ) , 'Sales'[SKU] = "Bananas" )
Measure 3:
Apple % of Banana = [GT Apples] / [GT Bananas]
Or, you could combine into one measure like this:
Apple % of Banana =
VAR
GT_Apples = CALCULATE( SUM( 'Sales'[Quantity] ) , 'Sales'[SKU] = "Apples" )
GT_Bananas = CALCULATE( SUM( 'Sales'[Quantity] ) , 'Sales'[SKU] = "Bananas" )
RETURN
GT_Apples / GT_Bananas
