Forum Discussion
Divide two columns DAX
Hello,
I need to calculate percentage and this is the DAX formula which isnt working:
PercentDifference= DIVIDE('Query1'[SALES]*100; 'Query1'[PLANNED_SALES] )
Divide function works if I put like this:
PercentDifference= DIVIDE('Query1'[SALES]*100; 2 )But when I put column PLANNED_SALES instead of number two... as a result I get empty column... Why is that? thank you!
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
11 Replies
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
Hi,
I am fairly new to this, so please bear with me.
I have two values from my dataset, both numerics. Drop and Connect, I need to show the Drop as a % of Drop and Connect, so created the below measure.
M_DropRate = VAR Drops = sum(Query2[Drops]) VAR DropsConnects = (sum(Query2[Connects]) + sum(Query2[Drops])) RETURN DIVIDE(Drops,DropsConnects)
When I add the measure to my table, it returns zero, but there are values in DROP and CONNECT. Any ideas??
Power BI gives error when I add a new column and type = IFERROR( ([Hedeflenen]-[Gerceklesen])/[Hedeflenen],0)
"Expression.Error: The name 'IFERROR' wasn't recognized. Make sure it's spelled correctly."
This syntax did not work for me: Percentage= DIVIDE([Sale];[PlannedSale])
Instead of an " ; " I had to use a comma. I should have read the example....🤣 But for those going quickly with copy and paste, RTFM! I had a headache for about 10 minutes before I caught this.
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?
