Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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])
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.