Forum Discussion
Creating Conversions in a matrix
Hi Anonymous,
You need to use the measures and the use the solution on this blog to make the measure as row in a matrix.
Check the PBIX file attach for an example just replace the measures on the file by the ones you need.
Regards,
MFelix
Hi,
thanks for your reply. It seems that this does not completely work for what I am needing.
Once I create the measures and make the switch matrix, the values that populate are incorrect:
Your fact table in the example file does not look like my fact table; this may be the problem here.
Hi Anonymous,
From the tests I made with different measures and table formats, I never got incorrect results with this approach.
Can you please share a copy of your PBIX file and expected results?
If you need you can share it through private message so you don't publish sensitive data or send a mockup file.
Regards,
Mfelix
I am not sure how to send links here. How do I attach it to the post?
Add a link of onedrive, google drive or wetransfer site on the edit link symbol of the chain on the side of the imogi.
Regards,
MFelix