Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
ARLA CAT ECOMM GROWTH = CALCULATE([YTD]-[LY YTD(2)])/[LY YTD(2)]
How can I change this formula to ignore any filters...using ALL?
Can someone write the DAX as I just can't get it to work?!
Solved! Go to Solution.
ARLA CAT ECOMM GROWTH = CALCULATE(([YTD]-[LY YTD(2)])/[LY YTD(2)],ALL(LinkToBrand[Brand])
That doesn't appear to be a full formul, but you could try:
ARLA CAT ECOMM GROWTH = CALCULATE([YTD]-[LY YTD(2)])/[LY YTD(2)],ALL('Table'))
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
That just gave an error:
ARLA CAT ECOMM GROWTH = CALCULATE([YTD]-[LY YTD(2)])/[LY YTD(2)],ALL(LinkToBrand[Brand]))
The syntax for ',' is incorrect. (DAX(CALCULATE([YTD]-[LY YTD(2)])/[LY YTD(2)],ALL(LinkToBrand[Brand])))).
ARLA CAT ECOMM GROWTH = CALCULATE(([YTD]-[LY YTD(2)])/[LY YTD(2)],ALL(LinkToBrand[Brand])
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!