Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |