Forum Discussion
sabizen
Helper I
1 year agoValue Associated With Min Value From Another Column
hello everyone, I would like to display in a table the value associated with the Min value of an additional table created on the fly. I tried to solve it by step. In STEP 1 I correctly generated th...
- 1 year ago
I think you can use
Bucket Measure = VAR SummaryTable = SUMMARIZE ( a_Master, a_Master[Data_rif], a_Master[ABI], a_Master[Bucket] ) VAR Result = SELECTCOLUMNS ( TOPN ( 1, SummaryTable, [bpv IR01], ASC ), a_Master[Bucket] ) RETURN Result - Anonymous1 year ago
Hi sabizen ,
Please try this:
Measure1 = VAR tab = SUMMARIZE ( a_Master, a_Master[Data_rif], a_Master[ABI], a_Master[Bucket], "valore", [bpv IR01] ) VAR imp = MINX ( tab, [valore] ) VAR bucket = CONCATENATEX ( FILTER ( tab, [valore] = imp ), 'a_Master'[Bucket], "," ) RETURN bucketBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
johnt75
Super User
1 year agoI think you can use
Bucket Measure =
VAR SummaryTable =
SUMMARIZE ( a_Master, a_Master[Data_rif], a_Master[ABI], a_Master[Bucket] )
VAR Result =
SELECTCOLUMNS ( TOPN ( 1, SummaryTable, [bpv IR01], ASC ), a_Master[Bucket] )
RETURN
Result
sabizen
Helper I
1 year agothis works as well!!! thank you so much