PowerBI use value from another table
Variables in DAX formulas
Let's make a summarized a table:
Profit_Table =
SUMMARIZECOLUMNS(
Orders[State],
Orders,
"Profit by state", sum(Orders[Profit])
)
Now, we have a separate excel file with 2 values
Let's make our summarized table use this profit value.
Profit_Acceptable =
var profitlimit = max(VariableTable[ProfitPass])
return
if(Profit_Table[Profit by state] >= profitlimit, 1,0)
I know what-if parameters can also be used, but in my experience
they tend to froze with big numbers.
