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

soubhik — Sat, 12 Dec 2020 06:22:56 GMT

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")))

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

Stachu — Sun, 13 Dec 2020 16:07:20 GMT

your syntax is invalid beacase MIN returns numeric value (as 'Table1[Num] is numeric) and you compare it with text (figher's name).
try this instead

FighterWithMinimumStrikes = VAR __fighters = ADDCOLUMNS(ALLSELECTED('Table1'[Fighters]),"Points",CALCULATE(SUM(Table1[Num]))) VAR __withRank = ADDCOLUMNS(__fighters,"Rank",RANKX(__fighters,[Points],,ASC,Skip)) VAR __result = CONCATENATEX(FILTER(__withRank,[Rank]=1),[Fighters],"") RETURN __result

and reference for the result

PointsForMinStriker = VAR __minStriker = [FighterWithMinimumStrikes] RETURN CALCULATE(SUM('Table1'[Num]),'Table1'[Fighters]=__minStriker)

topic How to input a value returned by measure to be inputed into a parameter? in DAX Commands and Tips

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

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