Excellove15
May 16, 2024Iron Contributor
Dax measure not returning the correct aggregate result
Hi SergeiBaklan
I created this measure shown below that returns a table with correct row values:
But the aggregate total -3036.53 is not correct and correct total we need is -1145.19.
Could you please help me as what needs to be corrected in the above measure for the correct total?
PFA file here Portfolio Performance - v2.12 - Copy (2).pbix
Thanks in advance sir!