Forum Discussion
Helper IRankX Dense
Hi 😧
I made a few changes. Brought brokers full name into your brokers table. Changed Date Table to mark as Date Table. Put new measures:
Total Sales
YTD Sales
Rank Brokers
I think instead of using implicit measures your better off using a measure. E.G. Total Revenue is implict. Total Sales is the measure to use. Also bring brokers name in your tables from brokers table. I don't think you need to show month sales like present. Use Month field from Dte table for all visuals. I hope this helps! I will send link in pers email.
Rank Brokers(YTD Sales ) = RANKX(ALL('Broker Table'[Full Name]), [YTD Sales],,DESC)Bill
Helper IHello,
I would appreciate more help with this rank issue. How would i go about sharing the pbix with you?
Solution SageHi 😧
I made a few changes. Brought brokers full name into your brokers table. Changed Date Table to mark as Date Table. Put new measures:
Total Sales
YTD Sales
Rank Brokers
I think instead of using implicit measures your better off using a measure. E.G. Total Revenue is implict. Total Sales is the measure to use. Also bring brokers name in your tables from brokers table. I don't think you need to show month sales like present. Use Month field from Dte table for all visuals. I hope this helps! I will send link in pers email.
Bill
- DeanUW
Hi,
Thank you for the adjustments you made. When I attempted to add the Rank measure you created on to the remaining pages that list out all 450+ brokers; the rank broke again, it ranked everyone 1. I will attempt to make the month column adjustments you recommended & see if that makes a difference.
- Whitewater100
Hi:
Yes, the adjustments should help with the measure. I noticed your fact table was joined on "pending" date, so that date is driving the results. I also saw the YTD and Total Sales measure yield same number. Hopefully that sounds correct to you.
Good luck!