Forum Discussion
Solved
problem with absolute difference calculation
Hello, I have a table containing the stock of several items for 2 softwares. I would like to compare the stock/item between the 2 softwares with an absolute difference. I tried the measure ...
Hi,
This measure works
Difference abs sumx = SUMX(SUMMARIZE('Table','Table'[Stock],'Table'[Item],"A",[Difference abs sum]),[A])Furthermore, you may simplify your measure to
Difference abs sum = ABS([Difference])Hope this helps.
Hi,
This measure works
Difference abs sumx = SUMX(SUMMARIZE('Table','Table'[Stock],'Table'[Item],"A",[Difference abs sum]),[A])Furthermore, you may simplify your measure to
Difference abs sum = ABS([Difference])Hope this helps.
Thank you, the summarize function works in my case !
You are welcome.