Forum Discussion
Help modeling situation "sample"
Hi, Anonymous
According to your sample data and the expected result, I found that there occurs a little problem in your sample data. The value I circled should be “CONTOPSA”, right?
Then I created a One to many, Both filter on these two tables, like this:
And I created a Matrix and a Slicer and place them like this:
And I guess this is what you want.
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHi Anonymous you need to create a relationship between both table by the PV that way you will get expected result.
In the example data you give things don't exatly match with the information you provide but has you can see the quantities match and therefore the price per kg.
Hola, Lamentablemente no me sirve mucho, me gustaría que resumiera por transporte y no me aparezcan 3 lineas iguales son el mismo transporte.
Cómo podría hacerse?