How to compare two dataset with different granularity?

[paolo_troia]

Hi all,

hope you are well!

I am struggling to compare the two dataset Platform1 and Platform2. I would like to compare impressions and clicks of Platform1 and Platform2, however this is what happens:

The data of Platform2 are no correct and I do not know how to fix it.

I made this data model but it is not working:

This is a problem I need to solve beacuse I have many dataset of this kind.

You can find the dataset excel file and the pbix file on the link below:

https://drive.google.com/drive/folders/1-5E58YHIjmrmC6BAgJBrcKL3z2Lxj0CX?usp=sharing 

I hope you can help me

Many thanks

Paolo

[rodrigosan]

Hello Friend. I uploaded the proposed solution to your folder. I could check and return if it suits you.

[PaulDBrown · Accepted solution]

You need to create dimension tables for fields common to both tables, As in:

You then use the dimension tbales in visuals, filters, measures, slicers...

 I've attached the sample PBIX file

[paolo_troia]

Thank you so much for your help! 🙂