Compare selected delivery schedule A with selected delivery schedule B

[veronika_prexl]

Hello, 

there are 10 delivery schedules, they are ranked 1-10 (1 = current, 2=last,...)

I want to select 2 of them and compare them.

I am able to write a measure to compare for example Rank1 and Rank2. 

My question:

I want to select 2 schedules (schedule A/schedule B). Ich want to compare selection A with selection B. How would this measure look like?

Thank you! Greetings from Austria

Veronika

[v-juanli-msft]

Hi @veronika_prexl 

Check if my solution satisfies your scenario.

• Create two table(not connected to any other table)

slicer1 = VALUES('Table'[schedules])

slicer2 = VALUES('Table'[schedules])

• Create measures

selected value =
CALCULATE (
    SUM ( 'Table'[value] ),
    FILTER (
        'Table',
        'Table'[schedules] = SELECTEDVALUE ( slicer1[schedules] )
            || 'Table'[schedules] = SELECTEDVALUE ( slicer2[schedules] )
    )
)

rank =
IF (
    MAX ( 'Table'[schedules] ) = SELECTEDVALUE ( slicer1[schedules] )
        || MAX ( 'Table'[schedules] ) = SELECTEDVALUE ( slicer2[schedules] ),
    RANKX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[schedules] = SELECTEDVALUE ( slicer1[schedules] )
                || 'Table'[schedules] = SELECTEDVALUE ( slicer2[schedules] )
        ),
        [selected value],
        ,
        ASC,
        DENSE
    )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.