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…