Forum Discussion
Solved
Divide function not giving right value
Hi all, in a tabel I have several measures displayed and in one of the measures i would like to calculate the margin% but it seems to give wrong value. 44/50=88% any idea where i might be do...
Probably a filter context issue...
What is the code for both measures and
what does each measure in the DIVIDE function deliver in a card visual?
Also what does the % measure deliver for the total row if added to the table visual?
Hi, jalaomar ;
I tested a simple data, if your table's filter is different from your card visual , so it may be cause the different result.such as:
1.when the table's filter is enddate is not 2021-2-1,the result is 4/5=0.8
2.if the table not have filter .it show 0.67
3.So keep the filter criteria consistent in every visual.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.