cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paolo_troia
Frequent Visitor

How to compare two dataset with different granularity?

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:

 

paolo_troia_0-1635602859260.png

 

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:

 

paolo_troia_1-1635603133901.png

 

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

 

1 ACCEPTED SOLUTION
PaulDBrown
Super User
Super User

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

model.JPG

 

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

result.JPG

 I've attached the sample PBIX file





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

3 REPLIES 3
rodrigosan
Advocate I
Advocate I

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

PaulDBrown
Super User
Super User

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

model.JPG

 

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

result.JPG

 I've attached the sample PBIX file





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Thank you so much for your help! 🙂

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!