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
amitnarkar3
Helper I
Helper I

TOTALYTD with DirectQuery

Hi All,

 

Could you suggest an aquivalent for TOTALYTD() function in DirectQuery mode?

This should work with Date Slicer selection.

 

Thanks,

Amit

1 ACCEPTED SOLUTION
Eric_Zhang
Employee
Employee

@amitnarkar3

 

You can try to click "File"->"Options and settings"->"Options"->"DirectQuery"->check "allow unstricted measures" to enable TOTALYTD.

 

Do mind the that using the unstricted measures would affect performance in DirectQuery mode.

View solution in original post

6 REPLIES 6
mattbrice
Solution Sage
Solution Sage

CALCULATE (
    SUM ( Table[Column] ),
    FILTER (
        ALL ( Calendar ),
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
            && YEAR ( 'Calendar'[Date] ) = YEAR ( MAX ( 'Calendar'[Date] ) )
    )
)

this also works only when I enable unrestricted option in power bi desktop. will it still work on power bi portal or azure portal?

Do we need to enable same thing in that case and from where I can do it?

@amitnarkar3

You just publish and don't have to change anything in Power BI Service.

Eric_Zhang
Employee
Employee

@amitnarkar3

 

You can try to click "File"->"Options and settings"->"Options"->"DirectQuery"->check "allow unstricted measures" to enable TOTALYTD.

 

Do mind the that using the unstricted measures would affect performance in DirectQuery mode.

thanks I could use it after the option is enabled.

@Eric_Zhang

 

I need to publish this on Azure portal, will it still work. Do I need to also enable this option anywhere else?

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.