Forum Discussion
Solved
Top N filter plus one specific item
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.
6 Replies
- tamerj1
Community Champion
Hi Totoro
Please refer to attached sample file with the solutionTop 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] )Many thanks tamerj1 for the code and pbix file! Should have posted the question earlier I have been struggling with it for weeks.
andhiii079845Solution Sage
I think this can help you:
https://community.powerbi.com/t5/Desktop/Rankx-with-filter/m-p/63457
Thanks andhiii079845 for the reference.
- wdx223_Daniel
It works! Brilliant! Thanks wdx223_Daniel.
Regards
Totoro
