Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi everyone! I have a table with some measures that i have created. The thing is that the totals doesnt show the correct number that it should, i think its because it treats the negative numbers as positive and it sums every row without distinct of positive and negative numbers.
Im attaching the PowerBI File , the sheet that matters is the first one (Repuestos). The columns that show wrong totals are Importe Neto, IVA, Facturado and Costo Total. How can i do to get the right totals having in consideration the positive and negative numbers as they truely are?
Thanks everyone!
Solved! Go to Solution.
Hi @feralvarez994
Please check it this is ok https://www.dropbox.com/t/rfLf1WPbPejF9H7b
@tamerj1 thanks a lot! it works fine, can you tell me why should i write first sumx and summarize? or why does the table didnt sum correctly?
@feralvarez994
You need to simulate the current filter context inside then sum the visible values as you see it in the matrix.
Hi @feralvarez994
Please check it this is ok https://www.dropbox.com/t/rfLf1WPbPejF9H7b
User | Count |
---|---|
20 | |
14 | |
11 | |
8 | |
6 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |