Summation across all rows of the minimum across columns

[Anonymous]

Example table below. The Column C is the minimum across columns A and B for the same row. The final, evaluated number is the sum of all the values in COlumn C. I'm lost as to how I'd implement this simple calculation in powerbi. Any help will be greatly appreciated.

A	B	C = min (A,B)
20	50	20
30	50	30
45	50	45
67	50	50
90	50	50
88	50	50
Sum of Col C	245

[Anonymous]

Thanks - it works perfectly. Much appreciated.

[amitchandak]

Thanks for the confirmation. Please mark the solution so that other can get benefitted from it

[amitchandak · Accepted solution]

@Anonymous , Try a new measure like

sumx(Table, if([A]>[B], [A], [B]))

Else create a new  column and then have sum

C = if([A]>[B], [A], [B])

[Anonymous]

A follow up question, if I may - is there a way to create a data table like in excel with the 'B' values varying from say 25 to 200, and the resultant sumx(Table, if([A]>[B], [A], [B])) providing the output in an adjacent column?