Based on filter selection need to show index numbers

[Jyo27]

Hi ,

Based on the filter selection , how to show index numbers . Suppose for category A it should show index number starting from 1 to 5 , for category B show satrting from 1 to 5 and so on .

Filter/slicer:

Category

A

B

C

Products	Category	INDEX
	A	1
	A	2
	A	3
	A	4
	A	5
	B	1
	B	2
	B	3
	B	4
	B	5
	c	1
	c	2

[v-zhangti · Accepted solution]

Hi, @Jyo27 

You can try the following methods.

Measure = IF(SELECTEDVALUE(Slicer[Category])=SELECTEDVALUE('Table'[ProductsCategory]),1,0)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jyo27]

Could anyone please help with this issue ?