Forum Discussion
Using Sum function and/or field in table
I am having this issue with inventory quantity in our Inventory Transactions table. I created a simple Sum function to show the qty. Measure.Qty = SUM(InventTrans[Qty]) To compare I insert...
rubayatyasmin
Community Champion
Community ChampionHi, Anonymous
1. Did you check for duplicated values in your table? If not you might want to check it.
2. You can try a card visual to see your result properly instead of a table visual. In the table, visual data gets filtered
If you want to sum distinct values only. You might want to use distinct function with SUMX
Did this solve your problem? If yes, hit đź‘Ť and accept this answer as a solution.