Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
hello,
I have this code made via virtual table that is bringing me a correct total result, however, line by line the result is incorrect.
Test in Dax Studio with the expected result:
When I change the expression after the RETURN to return the sum and insert this measure in the visual table, I have a correct total but the row-by-row result is incorrect:
Code used:
Note that in the column on the side the result is as expected, as this measure is the sum of the same calculations that I did in the virtual table, however, I executed it in a physical table with calculated columns, basically I created the calculated columns inside the SPREADSHEET table and created the measure Current sum curve:
Column 1:
Column 2:
Measurement:
Can anyone help me understand why this virtual table of mine is bringing the result row by row incorrectly when I add it to a visual?
Can you share your pbix file instead of the images ?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |