Forum Discussion
SWITCH Function in Matrix not working
Hi ChrisFromOhio ,
Not quite sure what you mean, you might consider displaying the corresponding MEASURES based on the slicer selection
Here are the steps you can follow：
1. Use Enter data to create a table with no join relationships that contains the names of the four measure：
2. Create measure.
Measure = var _select=SELECTEDVALUE('Slicer_Table'[Slicer]) RETURN SWITCH( TRUE(), _select = "Sales $",[Sales $], _select = "Sales U",[Sales U], _select = "Cost $",[Cost $], _select = "Margin %",[Margin %])3. Result:
If the results above don't match your expected results, you can express your expected results in the form of a picture and we can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi ChrisFromOhio ,
Not quite sure what you mean, you might consider displaying the corresponding MEASURES based on the slicer selection
Here are the steps you can follow：
1. Use Enter data to create a table with no join relationships that contains the names of the four measure：
2. Create measure.
Measure =
var _select=SELECTEDVALUE('Slicer_Table'[Slicer])
RETURN
SWITCH(
TRUE(),
_select = "Sales $",[Sales $],
_select = "Sales U",[Sales U],
_select = "Cost $",[Cost $],
_select = "Margin %",[Margin %])3. Result:
If the results above don't match your expected results, you can express your expected results in the form of a picture and we can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous
Thank you for your reply. Solution was to break the relationship. Thanks!
