Averagex with a unique Identifier as a filter

[mfloresb09]

Hey guys,

I appreciate the help. I want to create an expression that calculates the average price of different products filtered by a unique identifier in this case a contract number.

This is my data:

This is the expression I am working with but it is not applying the Contract filter and instead it is using the total average on the data.

[mfloresb09 · Accepted solution]

Hi, @HenriqueReis Thanks for the reply. So I am using trying to view this information as a value in a matrix that was already created. I was playing with the model relationships and I fixed the issue I was having. I appreciate your help. The above expression was correct.

[HenriqueReis]

That's great! haha

Regards!

[HenriqueReis]

Hi,

It's simple:

Create a measure like this:

Measure = average(All contracts advanced[price])

Then put your meassure in a card

And create a slicer and put your contract

Select just the contracts you want and then I think it's going to work

Regards!