Compare different month values for a measure , side by side, in a matrix with different measures

[Anonymous]

Hi all,

Im trying to create a matrix with headers like the following image, in order to be able to compare data from different months for the same measure side by side:

Each column ( Enviado Tipo Normal, Facturacion Neta and Ingresos x Cupon) are measures created from diferent 2 different fact tables that contain about 9 and 3 million rows.

I have been trying to find different solutions for quite a long time with no avail,  any clues on how to solve this?

Thank you for your time.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

As far as I know, this is impossible. Measure is calculated based on the current row context. The measure in the value field only corresponds to the current context, not the current context and different values are displayed repeatedly.

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

[amitchandak]

@Anonymous , do you need a measure on the top of the column? I doubt that is enabled in Matrix as of now

[Anonymous]

Thank you for your quick response,

Could this be achieved using a table such as the following, and using the measure column as a column in the matrix:

If the answer is yes, could I achieve this using a DAX formula?