Forum Discussion
Advocate IIDividing FIltered Value
Hello,
I tried to divide the value of one row to other calculated measure in other table. This the sample matrix below
I tried to calculate the success number (measure from other table) divided by costs (from other table (Ads Combined)). Both table connected through the dimension table (Source and Date). The "Cost" row actually has its own value in each row for each source and for each date
I tried to create my own measure below but it shows 0.00 result
Success Number divided by Cost =
calculate(divide([Success Number],sum('Ads Combined'[Cost])))
I'm not sure what went wrong or perhaps the code is just wrong.
Really appreciate if anyone can shine a light on this.
Thank you!
Hi aglpr
Nothing wrong. Your measure seems to be fine but the outcome of this division is a very small number that is rounded to zero. just change the format to percentage and increase the number of decimal places. Otherwise, double check and confirm which is the denominator and which is the numerator.
2 Replies
- tamerj1
Community Champion
Hi aglpr
Nothing wrong. Your measure seems to be fine but the outcome of this division is a very small number that is rounded to zero. just change the format to percentage and increase the number of decimal places. Otherwise, double check and confirm which is the denominator and which is the numerator.
aglprDear Tammer,
What a silly stupid mistake that I've made. I misplaced the numerator and the denominator.
Thank you so much for pointing it out. Feel so dumb right now
Thnak you once again!