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.
Hello all,
I'm trying to rank customers by the SUM (Total POS $) and am having difficulty getting Rankx to work as I would like it to. I have the following table: In this case, what I would like to do would be to aggregrate Total POS $ for each pos_end_customer_name for the month. I would like to ignore for the time being business_group and vp_area_description. Example on Feb 1st, I would like to aggregate $ for Zyteq (197 + 32) and rank this against all other unique customers throughout the rest of the month. I've tried the following:
Thanks!
Matthew
Solved! Go to Solution.
Hi @Matthew_Theis ,
To use this formula should work.
RANK C = RANKX ( salesdashboard_pos, CALCULATE ( MIN ( 'salesdashboard_pos'[Total POS $] ), ALLEXCEPT ( salesdashboard_pos, 'salesdashboard_pos'[pos_date], salesdashboard_pos[pos_end_customer_name] ) ), , DESC )
Hi @Matthew_Theis ,
To use this formula should work.
RANK C = RANKX ( salesdashboard_pos, CALCULATE ( MIN ( 'salesdashboard_pos'[Total POS $] ), ALLEXCEPT ( salesdashboard_pos, 'salesdashboard_pos'[pos_date], salesdashboard_pos[pos_end_customer_name] ) ), , DESC )
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |