Forum Discussion
Creating Conversions in a matrix
If I create a measure for each "conversion data" peice, I can not get it to be positioned as a 'row header'.
I want to pivot the conversions to align with the column headers for the Lead/Unit Data. Below, I added text to show where I want the CVR measures positioned; I am unable to correctly provide the values.
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?