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'm having trouble getting date slicers to work with my rank measure, slicing by other dimensions works flawlessy, it is just when date is introduced that the ranking breaks.
I've created a similar mock dataset of car sales and this is what it looks like below. AVG sales price is a simple measure dividing revenue by number of sales and is the measure I want to rank these cars by.
My goal is to create a ranking based on the AVG sale price which changes dynamically when slicing by Car Make, Car Year, Color, Date etc.
With this measure I am able to get everything working other than by date
Avg Sale Price Rank = RANKX(ALLSELECTED('Car Sales Mock'),CALCULATE([Avg Sale Price],ALLEXCEPT('Car Sales Mock','Car Sales Mock'[Car Make],'Car Sales Mock'[Color]),ALLEXCEPT('Calendar','Calendar'[Year],'Calendar'[Quarter],'Calendar'[Date])),,DESC,Dense)
Remove your Auto Date/Time stuff, it is not helpful.
Thanks for the tip, I removed it but unfortunately the measure still isn't working.
Any ideas on how I could rewrite the measure?
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 |
---|---|
107 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |