Showing results for 
Search instead for 
Did you mean: 
devonveach Frequent Visitor
Frequent Visitor

Matrix Grouping by Calculated Measure

I am trying to group a matrix by a calculated measure. I have been able to do this with a calculated column, where the column's values are dependent on the measure's outcome for each row. However, I want this measure to have switch functionality, that will change when a certain VALUES() selection is made. When I use this new measure with switch functionality in my calculated column, the values are determined based on the measure's outcome being zero, which I know it is not.


Any help with this specific problem or if there is a better way to group a matrix by a calculated measure please let me know.


Community Support Team
Community Support Team

Re: Matrix Grouping by Calculated Measure

Hi @devonveach ,


You want the results of a calculated column to be changed corresponding to the dynamical values of a measure, right? However, it is not possible, as calculated column is static once it has been initialized.



Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.