RankX based on Slicer selection in PowerPivot

Hi,

I do have a Datamodel with Dates, Machines and Index. They are related and in the worksheet I do have some slicers to filter.
Based on the slicer I want to have an Rankindex to find the worst machine. Then I want to create 3 Pivot tables and select these worst machines by ValueFilter Rankindex =1, =2, =3.

I do have the issue now that the rankx is not working as I wish:

Problems:
1.Rankx start to count with 2.
2.When filter the PvtTop10 by TOP 10 Value for RankIndex, I do get a complete different List then expected. The RankIndex is also different, but at least start with 1. I just want to keep the first 10 rows basically, not a new calculation of my RankIndex
3. If i go to the PvtTop1 and filter by rankindex =1, I do not see any data.

I guess if these 2 issues are fixed, the 3 one will be solved automatically

My formulas:

I tried RankIndex

Please Login or Register  to view this content.

and RankIndexIf

Please Login or Register  to view this content.

Both do the same, both have the same issues.

I tryed also other formulas, just dont get my desired results.
Any ideas?

thanks

hi

short update, in case someone is interested.
I managed to do the measure now.

RankIndexIF

Please Login or Register  to view this content.

Work like i want it to do

Guess I understand the formula better now, but still not an expert