cancel
Showing results for
Did you mean:
Highlighted
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

Accepted Solutions
Highlighted
Community Support

## Re: Measure based on filters slicers

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.
Highlighted
Community Support

## Re: Measure based on filters slicers

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.

Announcements

#### Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021