Invoice Number Check

Hi Anonymous ,

A first thing - please remove a summarization for the Rank column:

Second thing - please add Dense to Rank function as a last argument.

Rank = 
RANKX (
    FILTER (
        DAILY_BILLWISE_SALES,
        DAILY_BILLWISE_SALES[CAFEID] = EARLIER ( DAILY_BILLWISE_SALES[CAFEID] )
    ),
    DAILY_BILLWISE_SALES[BILLNO],
    ,
    ASC,
    Dense
    
)

The result:

pbix file: https://gofile.io/d/phJrox 
_______________
If I helped, please accept the solution and give kudos! 😀

Hi Bro,

The above method giving me inconsistent results.

For an example look at the below screenshot where i have filtered just one cafe.

Even though "BillNo" 102 is the first bill number it is showinng the rank as 21, because of this invoice Order too showing wrongly.

Column Used is = 

 

Measure used is 

 

Please help me on this bro.