Dax measure not returning the correct aggregate result
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!
Hi @Sergei Baklan 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! Read More