Forum Discussion
Measure total is different to row total
Hello, I have a rather common problem but I cannot implement any solutions correctly to my fuction. The function works correctly, showing the right rows and totals in a table I use to visual...
Figured it out. Just had to do a second measure with SUMX and multiply the problematic measure it by 1.
Hi, kkuntner
The total order value for late rows makes sense in this context, it might sound strange but in reality it's basically just value per row. Just the base column can't be used in a measure, SUM produces the same output. The answer is also correct per row, but not in total. That's how I know the formula works in row context, and I did do it part by part to achieve this.
Figured it out. Just had to do a second measure with SUMX and multiply the problematic measure it by 1.
Hello friend,
Do you know how to do it, can you give me an example?
thanks!
