Help troubleshoot DAX measure

[Vladracs]

Hello Experts,

Trying to understand how is it possible to get a wrong value (2x the actual value) just for 1 month (dezember) and 1 year (2018) in the example below:

Where the formula for Ultimo is:
Ultimo Valor*100 =
CALCULATE (
SUM ( 'FACT-TABLE'[Valor*100] ),
LASTDATE ( 'FACT-TABLE'[DATA] )
)

 

I would expect that all values are matching in the table above... no idea why or how to find out why this is happening 😕

any help would be greatly appreciated.

regards,
Vladimir

[Vladracs · Accepted solution]

sorry to bother you guys! there was a duplicate file in the folder I havent noticed . ignore this one

[Anonymous]

Hi @Vladracs ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[Vladracs]

Hello,

As you can see I am trying to display the last available data within a time frame. using 
CALCULATE (
SUM ( 'FACT-TABLE'[VALUE] ),
LASTDATE ( 'FACT-TABLE'[DATE] )
)
It works for pretty much all data set, but for the month of Dec 2018.

If you look at the screenshot, you see that I just put a table with both value at the month and the calculated value showing the last value (which in this case would be the same month) - note that I will apply this to a quarter or year later.

anyway, the point is the month value and the last data in the month value are the same! so there's no explanation of why 2018 is showing the value x2.