Forum Discussion

RoxyGCT's avatar
RoxyGCT
Regular Visitor
6 years ago

Productx Incorrect result using a measure

Hi there   I need to calculate a rolling return on a weighted average return (calculated in a measure). This is in theory 'working' but the results are a bit off, almost like the rounding isnt corr...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Way too much going on there to understand what exactly is happening but the column and measure would not have to return the same results as the column has row context and no filter context while the measure has only filter context. So, going to depend on a whole array of possibilities. 

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

RoxyGCT's avatar
RoxyGCT
Regular Visitor
6 years ago

Thanks Greg_Deckler , I might have been looking at this for too long and over explained!

 

I have simplified this and included the pbix. In short, the productx of a measure isn't generating the correct result when compared to excel, it is extreamely close which is why I think this could be a rounding issue.

 

https://www.dropbox.com/s/dciqrcsiu4eyvcu/fund%20analysis%20Sample.pbix?dl=0

https://www.dropbox.com/s/k4qejr511it9xnh/data6.csv?dl=0