DIVIDE false value

[powerbityro]

Hi all,

i have column C with a simple divide:

ColA - ColB - ColC

254 – 42 - 29,9 percent

But I get a wrong value (29,9 instead of 16,5 percent). I suppose it is because I use a matrix with a missing aggregation. it calculates it with the aggregation and takes than the average. How can I solve this problem?

Many thanks!

[Anonymous]

Hi @powerbityro ,

I'm not so clear about your data structure and dax formulas that you used in your visual. Can you please provide some sample data to help clarify your scenario?

In addition, did this result appears in common rows or total rows? If you mean total row, you can take a look at following link about measure total calculation issues:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[amitchandak]

Check You should be using 2nd formula

Avg = Averagex(table,colA/colb)

Avg2 = Divide(sum(A),Sum(B))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[parry2k]

@powerbityro share your sample data and expected output, Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490