-- create a datatable to populate the rows of a matrix
Metric Slicer =
DATATABLE("Metric", STRING,
{
{ "Units" },
{ "Gross $" }
}
)
-- create a measure to return the correct measure based on the row in a matrix
Loan Metric Selector =
SWITCH(
SELECTEDVALUE(
'Metric Slicer'[Metric]
),
"Units", [Loans Closed Count],
"Gross $", [Total Loan Amount]
)
No comments:
Post a Comment