ToHecWithRankX

[rsbin]

Good Evening @Greg_Deckler ,

Attempting to understand and replicate your message using CountRows instead of RankX.  However, having difficulty replicating the results shown in your message.  I have recreated your 'Table' and copied your Measure3.

GroupItemValueToHellWithRankXDescMeasure3

one	Item 1	700
one	Item 2	800
one	Item 3	900
one	Item 4	1000
Three	Item 10	12
Three	Item 8	200
Three	Item 9	1100
two	Item 5	500
two	Item 6	400
two	Item 7	300

ToHellWithRankXDescMeasure3 = 
    COUNTROWS(
        FILTER(
            SUMMARIZE(
                FILTER(
                    ALL('Table'),
                    [Group] = MAX([Group])
                ),
                [Item],
                "Value",SUM('Table'[Value])
            ),
            [Value]>=SUM([Value])
        )
    )

But I get a blank column.  Unable to figure out where or what I am doing wrong.  Hoping you can find or point out what I am missing. 

Once I get this, then I hope to be able to subsitute my own values and add some additional complexities and scenarios that I need to account for in my data set.

Thanks in advance and Best Regards,

[Jihwan_Kim · Accepted solution]