Forum Discussion
Divide two columns DAX
Hello all,
Thank you for you efforts. I finally found the solution.
What I needed to do was:
- create three measures:
Sale = SUM(Query1[SALES])*100
PlannedSale = SUM(Query1[PLANNED_SALES])
Percentage= DIVIDE([Sale];[PlannedSale])
Only this way worked for me and it is cool. Thank you guys
What are some of the values you have in rows where you are getting blank?
Can you please post a small screenshot showing the two columns being passed to the DIVIDE function, and the result.
When I put formula like this:
PercentDifference= DIVIDE('Query1'[SALES]*100; 2 )There is no error, and the column PercentDifference returns result just fine.
But, I need to put in the formula like this:
PercentDifference= DIVIDE('Query1'[SALES]*100; Query1[PLANNED_SALE] )In this case, the column PercentDifference is EMPTY. Like in the image:
Why, when I put second parameter (planned_sale) the result is nothing? But if I put number 2, it is fine
Right now I am testing:
I cannot even do this:
PERCENT_DIFFERENCE = DIVIDE(Query1[SALES]; Query1[PLANNED_SALE] )
Result is also EMPTY column, not zero, nor anything, just empty. Does it mean that DIVIDE function cannot divide two columns?
HI volkanbygl
What happens if you try a different operator.
PERCENT_DIFFERENCE_test = Query1[SALES] + Query1[PLANNED_SALE]
or even this
PERCENT_DIFFERENCE_test2 = Query1[SALES]
or
PERCENT_DIFFERENCE_test4 = Query1[PLANNED_SALE]
finally
PERCENT_DIFFERENCE_test = Query1[SALES] / Query1[PLANNED_SALE]
Are Query1[Sales] and Query1[Planned_sale] both physical columns, and not calculated columns or measures?
What does the column show in the Data View? Rather than using a visual
Hello,
thank you for being there.
What happens if you try a different operator.
PERCENT_DIFFERENCE_test = Query1[SALES] + Query1[PLANNED_SALE]
with plus operator, the result is good.
or even this
PERCENT_DIFFERENCE_test2 = Query1[SALES]
with assigning it 'copies' just fine
or
PERCENT_DIFFERENCE_test4 = Query1[PLANNED_SALE]
finally
PERCENT_DIFFERENCE_test = Query1[SALES] / Query1[PLANNED_SALE]
BUT, with / operator I get infinity in every row in a column
When I put * operator, the column is empty
what could it be?