Top N filter plus one specific item

[Totoro]

Hi

The data and desired outcome (top 3 in rank plus colour=pink if it is not in tope 3) are as below:

The measure Rank = RANKX(ALL(TableData[Colour]),CALCULATE(SUM(TableData[Stock]))) seems ok but the other measure

Top3+Pink = IF([Rank]<4 ||'TableData'[Colour] = "Pink",1,0) doesn't work.  Any advice please.  Thanks.

[tamerj1]

Hi @Totoro 
Please refer to attached sample file with the solution

Top 3 Stock = 
VAR T1 = 
    CALCULATETABLE (
        VALUES ( Data[Colour] ), 
        ALLEXCEPT ( Data, Data[Category] ) 
    )
VAR T2 = TOPN ( 3, T1, [Total Stock] )
VAR T3 = UNION ( T2, { "Pink" } )
VAR T4 = FILTER ( Data, Data[Colour] IN T3 )
RETURN 
    SUMX ( T4, [Total Stock] )

[Totoro]

Many thanks tamerj1 for the code and pbix file! Should have posted the question earlier I have been struggling with it for weeks.

[wdx223_Daniel · Accepted solution]

[Totoro]

It works! Brilliant! Thanks wdx223_Daniel.

Regards

Totoro

[andhiii079845]

I think this can help you:

https://community.powerbi.com/t5/Desktop/Rankx-with-filter/m-p/63457

[Totoro]

Thanks andhiii079845 for the reference.