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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

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!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!