Defining the position of the company - RANK

[krzysztof]

I have a problem with the creation of a measure that determines the position of company A in relation to other companies at a price.

https://drive.google.com/file/d/1P9Dtuv4m4boBElNUqFCqenWOPM1h3liK/view?usp=sharing               <-- pbx

[v-shex-msft]

HI @krzysztof ,

You can try to use following formula to calculate rank:

rank = 
VAR summary =
    SUMMARIZE (
        FILTER ( ALL ( Data ), [company] = "A" ),
        [company],
        [car_class],
        [car_gearbox],
        [localization],
        [days],
        "minPrice", MIN ( Data[cost_per_day] )
    )
VAR currPrice =
    CALCULATE (
        MIN ( Data[cost_per_day] ),
        FILTER (
            ALLSELECTED ( Data ),
            [company] = "A"
                && Data[car_class] = EARLIER ( Data[car_class] )
                && Data[car_gearbox] = EARLIER ( Data[car_gearbox] )
                && Data[localization] = EARLIER ( Data[localization] )
                && Data[days] = EARLIER ( Data[days] )
        )
    )
RETURN
    IF ( [company] = "A", COUNTROWS ( FILTER(summary,[minPrice]>currPrice ) )+1)

Regards,

Xiaoxin Sheng

[krzysztof]

Thank you @v-shex-msft for your response. Unfortunately, your calculation is not working properly, it shows very large numbers. In the picture, I described more precisely what I am asking for

[Zubair_Muhammad]

@krzysztof 

Also we can use RANKX function

Measure 2 =
RANKX (
    VALUES ( Data[company] ),
    CALCULATE ( MIN ( Data[cost_per_day] ) ),
    [lowest price company A],
    ASC,
    DENSE
)

[Zubair_Muhammad · Accepted solution]

@krzysztof 

Give this a shot

Measure =
COUNTROWS (
    FILTER (
        VALUES ( Data[company] ),
        [lowest price company A] > CALCULATE ( MIN ( Data[cost_per_day] ) )
    )
) + 1