cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

## Measure based on filters slicers

Hi guys,

I have this model in the center products table, in the left side, prices lists ( I have many lists and each product may have different prices according to the list) and in the right side, the parents from these products .

I'm trying to do a measure to know the total amount on each product depending on price list ( from inliprix)  and on qty ( from struc_act)

I have this pivot table with the following measure in pivot column and two slicer to filter prices lists and parents

`Measure = CALCULATE(AVERAGE(inliprix[price_list])*AVERAGE(Struc_act[qty]))`

At the end a want to show in a field Qty x Price according to price list number (6 and 8 in the exemple) and subtotal by prod parent

I'm not sure about average I used in my measure but I don't know what to do

Pep.

1 ACCEPTED SOLUTION
Community Support

As the sample you shared, I think that you want to correct the total, you can change your measure to following:

```Test =
VAR t =
FILTER (
inliprix,
inliprix[list_number] = SELECTEDVALUE ( inliprix[list_number] )
)
RETURN
SUMX (
t,
[price_list]
* AVERAGEX ( FILTER ( 'Struc_act', Struc_act[Code-prod] = [Code-prod] ), [qty] )
)```

BTW, pbix as attached.

Best regards,

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support

As the sample you shared, I think that you want to correct the total, you can change your measure to following:

```Test =
VAR t =
FILTER (
inliprix,
inliprix[list_number] = SELECTEDVALUE ( inliprix[list_number] )
)
RETURN
SUMX (
t,
[price_list]
* AVERAGEX ( FILTER ( 'Struc_act', Struc_act[Code-prod] = [Code-prod] ), [qty] )
)```

BTW, pbix as attached.

Best regards,

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.