Forum Discussion
Measures & Switch & Customized Matrix - calculation using measures & assignment to custom matrix
Hello All, My scenarion: - I have fully customized matrix - I would like to keep sum of values in the measures - I would like to assign measures to the customized matrix using SWITCH functi...
Hi Anonymous
First, returning a mixture of data types from a measure is a VERY BAD idea. Refrain from doing this or you'll suffer rather sooner than later. You should not return an empty string "" from the SWITCH measure. Just remove the piece from the formula and DAX will automatically return BLANK if no option out of the list is selected, which is the correct thing to do. It might even fix your problem...