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 have a mock table with 1000 rows of car sales data, shown above. There are only a handful of different car combinations and I am interested in seeing what the average selling price is across a time period, which is simply a measure of Total Revenue / Number of Sales
The above table is looking at the car sales breakdown minus the date. It is sorted by
@vendersonalias0 , Try once like this
RANKX(ALLSELECTED('Car Sales Mock','Car Sales Mock'[Car Make],'Car Sales Mock'[Car Year],'Car Sales Mock'[Color]),CALCULATE([Avg Sale Price]),,DESC,Dense)
I have not checked the file yet
Hi, thanks that seems to be very close, it is now working wiht the date slicer but it is skipping some numbers if the car didn't have any sales that month
Thanks, it seems liek were a step closer but there are still some weird variations such as two rank 7, and osmetimes they will skip a rank.
I did have to adjust your measure to remove the table reference 'car sales mock' since it said that multiple argumetns are not allowed in the allselected function when the first argument is a table refrence.
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 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |