Forum Discussion

Laurent123's avatar
Laurent123
Regular Visitor
2 years ago
Solved

Sorting data from 3 tables.

Hello, I have 3 tables.   Table A where I have my work orders.   Work order Work order 1 Work order 2 Work order3   Table B with all the parts used during those work ord...
  • Anonymous's avatar
    Anonymous
    2 years ago

     Hi Laurent123 

    I updated my measure formula and it now shows correctly

     

    Total Price =

SUMX(

    'Table 2',

    'Table 2'[Qty] * RELATED('Table 3'[Price])

)

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Laurent123 

 

Here are the three tables you provided, The relationship between them has been properly established

 

 

 

Based on your three tables, you can build such a table in the Report View interface

 

 

You can create such a measure to calculate  total price per line

 

Total Price = MAX('Table 2'[Qty])*MAX('Table 3'[Price])

 

Then you can put this measure into the table

 

 

Then you can create a slicer and drag the Work order field into the slicer

 

 

This is the result you want, each time you select an option in the slicer, the values in the table will change as well

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

  • Laurent123's avatar
    Laurent123
    Regular Visitor
    2 years ago

    Hello,

     

    THanks for helping.

     

    The Total looks wrong

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

       Hi Laurent123 

      I updated my measure formula and it now shows correctly

       

      Total Price =

SUMX(

    'Table 2',

    'Table 2'[Qty] * RELATED('Table 3'[Price])

)