Please advise on the issue below.
I have created 3 measures in order to display the % change of sales when selecting a year and it goes like this:
1) I've created a measure to calculate total sales: Total Selected Sales = sum('to'[Turnover])
2) I've created a measure to calculate Prior Year Sales:
Prior Year Sales =VARselectedYear = if( HASONEVALUE('DateKey'[year]),FIRSTNONBLANK(DateKey[year],DateKey[year]),BLANK() )-1ReturnCALCULATE(SUM('to'[Turnover]),ALL('to'),DateKey[year] = selectedYear)
3) A measure which displays the increare/decrease in %: Percent Change = DIVIDE([Total Selected Sales],[Prior Year Sales],1)-1
Everything works fine when i'm applying a Year filter as you can see below.
When i'm also applying a filter to a lowest level, (brand), to check the sales for a specific shop in a shopping mall, the Prior Year Sales remains the same.
I can't understand why Prior Year Sales doesn't apply to the Brand level (the information is in the same table, it's not a relationship problem).
Go to Solution.
In your CALCULATE function call, the “ALL(‘to’)” is blocking the filter on Brand. From what I see it should be removed.
View solution in original post
Thanks for your reply.
Tried removing it, still having the same result.
On second thought, it works.
thanks a lot!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Find out where you can attend!