TOTALYTD is not summing up

[digant]

Hi,

For some reason TOTALYTD doen't seem to SUM up value correctly. I have created following steps

1) Created dimension Calender table 

2) Actual data has date field in dd/mm/yyyy format

3) Created relationship between those tables

4) Defined measures as  below

SumOfGrossRevenue = SUM(EnhacedHeracles[Gross Revnue])

YTDSumOfRevenue = TOTALYTD([SumOfGrossRevenue],'Calendar'[Date])

5) YTDSumOfRevenue seems to repeat SumOfGrossRevenue rather than performing YTD

Table Definition

Can someone please help here what seems to be issue ?

regards

Digant

[v-ljerr-msft]

Hi @digant,

YTDSumOfRevenue seems to repeat SumOfGrossRevenue rather than performing YTD

---

Could you be more precisely with the issues by posting some sample data with the current result and the expected result? It's better that you can also share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[digant · Accepted solution]

Hi,

Apology for delyed response. I manage to sort out issue. Due to date filter, I had to use below formulae.

YTD-A-Book = CALCULATE(TOTALYTD(SUM(EnhacedHeracles[Gross Revnue]),'Calendar'[Date],ALL('Calendar'),"06/30"),EnhacedHeracles[book]="A")

MTD-A-Book = CALCULATE(TOTALMTD(SUM(EnhacedHeracles[Gross Revnue]),'Calendar'[Date],ALL('Calendar')),EnhacedHeracles[book]="A")

Regards,

Digant