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")))
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)
Proud to be a Super User!
User | Count |
---|---|
51 | |
22 | |
15 | |
13 | |
12 |
User | Count |
---|---|
42 | |
23 | |
20 | |
19 | |
17 |