Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Bokchoy
Helper II
Helper II

Sub total of "totalytd"

Hi everyone,

 

I'm using a totalytd measure to calculate my target per period. The period target will steadily increase from the previous period. 

DAX: Period Revenue Target Div = (totalytd(sum('Budget'[AcumulativePeriodRevenueTarget]),DimCalendar[Date],"06/30"))

As shown in the table below, the total shown is not the actual target for the year, it's showing the lastest period target.
How can I get the table to show the total target for the financial year?
Bokchoy_0-1620616407301.png

 

Thanks in advance.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Bokchoy , Try like

sumx(Values(DimCalendar[year])totalytd(sum('Budget'[AcumulativePeriodRevenueTarget]),DimCalendar[Date],"06/30"))

 

You have to use the group by of the table

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Bokchoy , Try like

sumx(Values(DimCalendar[year])totalytd(sum('Budget'[AcumulativePeriodRevenueTarget]),DimCalendar[Date],"06/30"))

 

You have to use the group by of the table

It worked.

 

Thank you kindly 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.