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.
Hi,
I have to display current year sales and compare it to last year sales. I created three measures in order to do it:
SalesTotal = SUM( Orders[Sales] )
SalesYTD = TOTALYTD( [SalesTotal] ; 'Date'[Date] )
SalesYTDLastYear = CALCULATE( [SalesYTD]; SAMEPERIODLASTYEAR( 'Date'[Date] ) )
Solved! Go to Solution.
Hi,
My guess is that for Technology, the % in the card visual evaluates to an error. What is the measure for %? Also, what error do you get when you click on Voir Les Details? Share the link from where i can download your PBI file.
Hi,
My guess is that for Technology, the % in the card visual evaluates to an error. What is the measure for %? Also, what error do you get when you click on Voir Les Details? Share the link from where i can download your PBI file.
Thanks, I did not even think of reading the error message:
MdxScript(Model) (18, 60) Calculation error in the measurement'Orders'[ProfitYTDLastYear] : The "SAMEPERIODLASTYEAR" function expects a contiguous selection when the date column comes from a table on side 1 of a bidirectional relationship.
After reading this, I changed the relationship between my tables 'date' and 'orders' as single.
I will search for documentation about "cross-filter direction" (here I found something).
You are welcome.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |