Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dears,
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 =
VAR
selectedYear = if( HASONEVALUE('DateKey'[year]),
FIRSTNONBLANK(DateKey[year],DateKey[year]),
BLANK() )-1
Return
CALCULATE(
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).
Any ideas?
BR,
Andrei
Solved! 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.
In your CALCULATE function call, the “ALL(‘to’)” is blocking the filter on Brand. From what I see it should be removed.
On second thought, it works.
My mistake!
thanks a lot!
Hi Matt,
Thanks for your reply.
Tried removing it, still having the same result.
thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |