Procurement dashboard

[ShraddhaA]

I have data related to Purchase order description, vendor name and vendor code. How do i create a metric on the dashboard that shows if the same material has been purchased from different vendors at different price.

[v-yangliu-msft · Accepted solution]

Hi  @ShraddhaA ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
CONCATENATEX(
    FILTER(ALL('Table'),
    'Table'[material]=MAX('Table'[material])&&'Table'[vendor code]=MAX('Table'[vendor code])),
    'Table'[vendor name],"-")

2. Result:

Best Regards,

Liu Yang

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