Show all values for specific segment and show top 3 for others - RANKX

[NandhuE31]

I have the following structure of data. 

Category	Segment	Brand	Sales
A	S1	B1	100
A	S1	B2	0
A	S2	B3	120
A	S5	B4	140
A	S1	B9	20
A	S1	B21	25
A	S2	B33	130
A	S5	B20	90
A	S1	B10	0

I want to show sales for all the Segment S1 and Top 3 in other Brands. 

Result expected : 

Category	Segment	Brand	Sales
A	S1	B1	100
A	S1	B2	0
A	S1	B9	20
A	S1	B21	25
A	S1	B9	20
A	S1	B10	0
A	S5	B4	140
A	S2	B33	130
A	S2	B3	120

[NandhuE31]

I have other filters in the data. It would be difficult to make them work asd calculated table .

Can it be done as measure or as calculated column?

[CNENFRNL · Accepted solution]

Hi, @NandhuE31 , you might want to try a more flexible pattern; you can slicer the segments for keep certain segment while filtering other segments down to top 3. Pls refer to the attached file for details.

[sanalytics]

Hi @NandhuE31 

Assuming you want your expected result as Calculated Table

Then below Dax can help to achive this

Attached link is the Power BI file

https://dropfiles.org/Ml63iGvD

Regards

sanalytics

if it is your solution then please like and please accept it as solution