Matrix Grouping by Calculated Measure

[Anonymous]

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.

Thanks

[v-yulgu-msft]

Hi @Anonymous ,

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.

Regards,

Yuliana Gu