show top 50 customers on table static

[raj777karthik]

Hi,

Need to show top 50 customers per collection based on created date in table Power BI.Have created below measure as well.

But in table since we have other columns it is showing top customers based on other columns. This should be static it should not change once added  in table.

Measure=
var __MAX_VALUES_TO_SHOW= 5

return

    CONCATENATEX(

                TOPN(

                    __MAX_VALUES_TO_SHOW,

                    table,table[column],

                    desc,table[tablecolumn],desc

                ),

                CALCULATE(min('column]),ALLEXCEPT(collection,table[id])),

                ", ",

                'table '[CreatedOn Date],

                desc

            )

[Anonymous · Accepted solution]

Hi @raj777karthik ,

I can't speculate on the data based on your formula. I have create a simple sample.

Please have a try.

Create a measure.

_rank__ = RANKX(FILTER(all(collection),collection[collection]=SELECTEDVALUE(collection[collection])),CALCULATE(SELECTEDVALUE(collection[create date])),,ASC)

Then filter the date.

If I have misunderstood your meaning, please provide your pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@raj777karthik not really clear what you are looking for Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490