Want to show top 3 category in each region

[AshDil]

Hi,

I have data as follows,

REGION	CATEGORY	SUB_CATEGORY	VALUE
EAST	H	GH	50
EAST	G	FL	100
EAST	H	KP	50
EAST	G	IO	80
EAST	K	ZX	70
EAST	L	HM	90
EAST	M	RO	45
WEST	N	PE	62
WEST	Q	CH	40
WEST	R	UV	67
WEST	R	IR	73
WEST	TU	RE	50
WEST	X	DE	74
CENTRAL	W	BC	88
CENTRAL	V	HG	92
CENTRAL	V	IQ	106
CENTRAL	Z	AB	110
CENTRAL	L	ST	54
SOUTH	M	YS	18
SOUTH	O	JS	60
SOUTH	E	PO	40
SOUTH	F	LI	200
SOUTH	G	BM	50
SOUTH	H	GM	150
SOUTH	V	UT	50

I want to show top 3 cat as follows:

Please help me to do it.

Thanks,

AshDil.

[Jihwan_Kim · Accepted solution]

Hi, 

please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

[AshDil]

Hi @Jihwan_Kim ,

Thanks for your help. It worked for me.

Thanks,

AshDil.

[Fsciencetech]

@AshDil check out this link

https://radacad.com/topn-dax-function-how-it-works-in-power-bi-comparison-against-the-top-group

[Fsciencetech]

Hope this measure will help you

Top3Category =

 VAR Rank = Values(Table[Category])

Return

Calculate (

[Total value],

  TOPN(3, All(Table[Category]), [Total value]), Rank)