Forum Discussion

Hijau's avatar
Hijau
Frequent Visitor
8 years ago
Solved

Divide function not showing correct result

Hi community,   I'm trying to use the divide function but it's not showing the correct results for me. The formula looks like this:    Omloopsnelheid = DIVIDE(SUM(GRV_StockpositionsPerDay[Stock])...
Need Help
Tips and Tricks
  • gipiluso's avatar
    gipiluso
    8 years ago

    it seems that the two table is not properly related.

    Look to whats append if you bring the "Eruit positief" column in the first table.

     

    If you don't solve post the pbix, i'll try to take a look.

    GP

quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi Hijau

 

If you don't use SUM function, does it display the correct value ? 

 

 - Quentin 

  • Hijau's avatar
    Hijau
    Frequent Visitor
    8 years ago

    If I just divide the columns without using DAX it gives the same answer. Also when I use divide the numerator and denumerator need a function I believe.