Compare Total and details of data with different data description.

[Anonymous]

Hi Power BI Users,

I have the following scenario, two sets of data, in one set I have an Id with a description and the total value, in the other set I have the same Id with the details of the total and other descriptions.

Total:

Details:

In Power BI I compare the two dataset as follow:

I would like to display not only the import but also the descriptions, as you can see the description for the total value is duplicated because of in thr table there is also the descriptions for the detailed import. The final scope is to compare the total between the two table and find difference, I tried with a matrix visualization.

I would like to avoid (if possibile) the repeated import for the total and for the description of totale.

Thank you in advance!

[Anonymous]

so what do you want?

Share sample data and expected output.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous · Accepted solution]

Sorry I missed half of messagge during the publication ahahah. Now it's fixed.

[Anonymous]

You are getting expected result only.

Thanks
Pravin