Forum Discussion
Matthew_Theis
Advocate II
Advocate IIRankx an Aggregated Fieldin a calculated column while ignoring others.
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...
AlB
Community Champion
Community ChampionCan you please share the table in the screen capture in text-tabular format so that it can be readily copied? Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).
Matthew_TheisHere you are AlB Thanks in advance.
pos_date business_group vp_area_description pos_end_customer_name Total POS $ Total POS Q Rank C Rank Customers by Month Rank Customers by Month by BG Index Friday, February 1, 2019 CBG EUROPE ZYTEQ TECHNOLOGIES 70 632 #ERROR 26519 12694 1823291 Friday, February 1, 2019 CBG EUROPE ZYTEQ 197 2160 #ERROR 19180 9143 1823289 Friday, February 1, 2019 FEBG EUROPE ZYTEQ 32 210 #ERROR 32680 8170 1823290 Friday, March 1, 2019 CBG AMERICAS ZYNEX MEDICAL INC 17 400 #ERROR 23955 12577 1856519 Friday, February 1, 2019 CBG AMERICAS ZYNEX MEDICAL 563 20000 #ERROR 12414 5920 1823287 Friday, March 1, 2019 CBG AMERICAS ZYNEX MEDICAL 15 370 #ERROR 24527 12915 1856518