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.
I can't do a small table that gives me sales and last year sales by category,
here is the measure that stays empty each time i choose a filter, if i don't have any filter it's working, i have my sales till end of 2020
Last year Sales =
VAR Val = CALCULATE(SUM('PBI Sales'[Sales price]), SAMEPERIODLASTYEAR('PBI Date'[Date]) )
VAR Result = if(ISBLANK(Val),0,Val)
RETURN Result
Please help i feel so dumb right now i don't understand why it's not working .
here is the image of the table , i'm not always easy to understand , that may help
Solved! Go to Solution.
I finally found my problem, i didn't mark PBI table as date table.
Hi @oupepasa ,
Is your page slicer using [Year] from your 'PBI Date' table, or from your fact table? If it's from your fact table, then you need to switch it to 'PBI Date'[Year] as it may be an issue with relationship filters not being able to be passed from the fact table to the date table due to filter direction.
Pete
Proud to be a Datanaut!
Thanks for your answer, but my slicer is from my 'PBI date' table
Ok. Are you able to share an example of your data and a picture of the relevant parts of your data model please?
If so, make sure to remove any sensitive information from the data sample.
Thanks,
Pete
Proud to be a Datanaut!
I finally found my problem, i didn't mark PBI table as date table.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |