Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
@Anonymous , do you need a measure on the top of the column? I doubt that is enabled in Matrix as of now
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |