Use Measure as a Column

Hi, Anonymous 

I think it is unsupported to use a measure in rows or columns in a matrix visual. Values in rows and columns should be determined. Even if measures and columns look similar, there is a big difference between calculated columns and measures. The value of a calculated column is computed during data refresh and uses the current row as a context; it does not depend on user activity on the pivot table. A measure operates on aggregations of data defined by the current context. In a pivot table, for example, source tables are filtered according to the coordinates of cells, and data is aggregated and calculated using these filters. In other words, a measure always operates on aggregations of data under the evaluation context.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.