Using slicer value in a DAX calculation

[btreg]

Thanks to help from an earlier thread, I am using the following measure in my model:

MINX (
TOPN ( 2 , VALUES (Basic_Level_Mode_Fees[Provider short name]), CALCULATE ( [Sum_FTE] ) ),
CALCULATE ( [Sum_FTE] )
)

I want the report user to be able to control the number 2 by selecting from the numbers 1 to 10 in a slicer.

I have created a disconnected table called 'Rank' containing the values 1 to 10 and created a slicer from this table. I've then amended the formula as follows:

MINX (
TOPN ( VALUES (Rank[Rank]) , VALUES (Basic_Level_Mode_Fees[Provider short name]), CALCULATE ( [Sum_FTE] ) ),
CALCULATE ( [Sum_FTE] )
)

However, this returns the error message "A table of multiple values was supplied where a single value was expected" even when a single value (e.g. "3") is selected with the slicer. I thought that selecting "3" with the slicer would filter the 'Rank' table to a single value (3)?

Can anyone advise what I doing wrong?

Also, are there any alternative methods to gathering the input of a number from 1 to 10 from the user, other than using a slicer? Can a DAX formula refer to a cell in an Excel worksheet, controlled by a spin button, for example)?

Any help much appreciated.

 

[akice]

Change VALUES (Rank[Rank]) to MIN (Rank[Rank]) ( or MAX() )

 

[btreg]

Perfect, that has fixed it, thank you!