Compare price to average prices for same selections

[PeterStuhr]

Hi all, I have a Supplier table with the following:

[SupplierID], [Job Type], [Product], [Price].

So I am doing a matrix showing SupplierID --> Job type --> Product, and the Price for each of those.

What I need is to also show the average, not split by Supplier.

Example: 

SupplierID	Job Type	Product	Price
1	Service	Beer	20
2	Service	Beer	40

In the Matrix I want to show that for Supplier 1, the Price for Service and Beer is 20, while the Average of Service and Beer is 30. So I can see that Supplier 1 is the cheapest. Ofcourse we have many combinations of Job Type and Product, but this is the idea. best regards!

[lkalawski]

@PeterStuhr ,

You can create the measure:

Prive Avg =
CALCULATE (
    AVERAGE ( 'Table'[Price] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Job Type] = SELECTEDVALUE ( 'Table'[Job Type] )
            && 'Table'[Product] = SELECTEDVALUE ( 'Table'[Product] )
    )
)

_______________
If I helped, please accept the solution and give kudos! 😀

[amitchandak]

@PeterStuhr , Try this measure -

calculate(average(Table[Price]), allexpcept(Table,Table[Type],Table[Product]))