Measure to rows header

[Duong]

Hi all,

I'm looking to create a matrix chart that displays the frequency of repeating orders.

I have created a measure below. This measure is used for the values in the matrix. I intend to use the column [No_repetitions]

of the 'table_groupby' for the rows header.

This is the results as I want.

However, I believe it's better to use [No_repetitions] as the measure. This way, when filtering by datetime, [No_repetitions] changes accordingly.

For example:
OR********* has repeated 5times in my list, so the result of No_repetitions shoulde be 5.

But when I filter datetime from 13-Feb to 20-Feb, the result of No_repetitions shoulde be 3.

Kindly tell me how I would be able to display the result of measure in form of rows header.

[Anonymous]

Hi @Duong ,

Sorry, I don't fully understand your needs yet. But I can make the following points clear:

1.Measures cannot be placed in rows or columns of a matrix, only Values can.

2.The row header refers to the field name in the matrix, right? And it cannot be returned in the row header as a measure.

3.Your [No_repetitions] is a column, but because of the relationship between tables, it can also be filtered by filters, provided that there are no formulas in your matrix that ignore filters.

Best Regards,

Stephen Tao

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