Forum Discussion

rsbin's avatar
rsbin
Community Champion
5 years ago
Solved

ToHecWithRankX

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

oneItem 1700 
oneItem 2800 
oneItem 3900 
oneItem 41000 
ThreeItem 1012 
ThreeItem 8200 
ThreeItem 91100 
twoItem 5500 
twoItem 6400 
twoItem 7300 

 

 

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,