How can I return different unioned tables depending on a SELECTEDVALUE() variable using below? tyia!
tbl_generic =
var tbl1 =
CALCULATETABLE(
SELECTCOLUMNS(
'production product',
"idx", 'production product'[productid],
"productname", 'production product'[name]
)
)
var tbl1 =
CALCULATETABLE(
SELECTCOLUMNS(
'product',
"idx", 'product'[productid],
"productname", 'product'[name]
)
)
var tbl2 =
CALCULATETABLE(
SELECTCOLUMNS(
'category',
"idx", 'category'[categoryid],
"categoryname", 'category'[name]
)
)
var x = 1 // will be from a SELECTEDVALUE()
var _tbl = if(x= 1, tbl1, tbl2)
return
UNION(
_tbl,
DATATABLE("idx", INTEGER, "xyz", STRING, {{-1, "Others"}})
)
