Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |