What If Analysis with Multiple Columns
I have a fact table Date Category Qty Price Jan 1 Biscuits 5 10 ------ Say Monday Jan 2 Fruit 7 ...
Forum Discussion
amitchandak
Super User
Super UserGR83 , Try a measure like
Sum( Table,
Switch([Category],
"Fruit", selectedvalue(FruitParam[Value]) ,
"Biscuit",, selectedvalue(BiscuitParam[Value]) ,
// add others
) * [Qty]*[Price])
I how do I use Table in Sum and Category In Switch?
