How to input a value returned by measure to be inputed into a parameter?

[soubhik]

How to input a value returned by measure to be inputed into a parameter?

So, I am using a nested min to get the minimum value of prices and return the name of the fighter with minimum strikes

But I want the value returned to be inputed into a parameter, so that it can be used later in different scenario

I created a nested if to return the fighter name for minimum strikes.How do I input the value returned by this measure into a parameter? For eg, I have a card that displays the hand strikes of the fighter with minimum strikes. How to populate that dynamically? 

Attached PBIX: https://drive.google.com/file/d/1l_THibyAAOuHnUDydw1GtgVFy6FXvZnX/view?usp=sharing"

Measure = 
var _Conor=calculate(SUM(Table1[Num]),FILTER(Table1,Table1[Fighters]="Conor"))
var _Nate=calculate(SUM(Table1[Num]), FILTER(Table1,Table1[Fighters]="Nate"))
var _GSP=calculate(SUM(Table1[Num]), FILTER(Table1,Table1[Fighters]="GSP"))
var _Jon=calculate(SUM(Table1[Num]), FILTER(Table1,Table1[Fighters]="Jon"))
return
if(MIN(_Conor,MIN(_GSP,MIN(_Nate,_Jon)))="Conor","Conor",
if(MIN(_Conor,MIN(_GSP,MIN(_Nate,_Jon)))="Nate","Nate",
if(MIN(_Conor,MIN(_GSP,MIN(_Nate,_Jon)))="GSP","GSP","Jon")))

[v-yingjl · Accepted solution]

Hi @soubhik ,

In your formula, the values of variables are numbers while you compare them with text type in the IF statement, it is not allowed in power bi and will show errors in the visuals.

You could modify the formula like this, compare them with themselves instead of text value

VAR _Conor =
    CALCULATE ( SUM ( Table1[Num] ), FILTER ( Table1, Table1[Fighters] = "Conor" ) )
VAR _Nate =
    CALCULATE ( SUM ( Table1[Num] ), FILTER ( Table1, Table1[Fighters] = "Nate" ) )
VAR _GSP =
    CALCULATE ( SUM ( Table1[Num] ), FILTER ( Table1, Table1[Fighters] = "GSP" ) )
VAR _Jon =
    CALCULATE ( SUM ( Table1[Num] ), FILTER ( Table1, Table1[Fighters] = "Jon" ) )
RETURN
    IF (
        MIN ( _Conor, MIN ( _GSP, MIN ( _Nate, _Jon ) ) ) = _Conor,
        "Conor",
        IF (
            MIN ( _Conor, MIN ( _GSP, MIN ( _Nate, _Jon ) ) ) = _Nate,
            "Nate",
            IF ( MIN ( _Conor, MIN ( _GSP, MIN ( _Nate, _Jon ) ) ) = _GSP, "GSP", "Jon" )
        )
    )

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.