Creating Conversions in a matrix

[Anonymous]

Hi, 

I am wanting to replicate a report in Power BI. 

I have some "Conversion Data" that's based on some metrics from our server:

This is how the fact table looks (with the individual metrics in the "Metric" column:

I already know that creating a separate pivot is ideal; but I can not get the format i am wanting - this is my result:

What are tips get the view I want ??

Thanks!

[MFelix]

Hi @Anonymous,

Not really sure of what is your main goal in this question.

Do you want to return the CONVERSION DATA part to your PBIX file? If so you need to create measure for each of the Conversion metrics based on the LEAD/UNIT DATA.

Can you explain a little bit better and give examples of the calculations and expected results.

Regards,

MFelix

[Anonymous]

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.

[MFelix]

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 

[Anonymous]

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. 

[MFelix]

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

[Anonymous]

I am not sure how to send links here. How do I attach it to the post?

[MFelix]

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

[Anonymous]

Conversion Help

[vazmor]

i try

Solution

[Anonymous]

I don't see a change in your file.

[vazmor]

sorry, link correct

Solution