Measure based on filters slicers

[PepitoTratado]

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

Thanks in advance

Pep.

[v-lid-msft · Accepted solution]

Hi @PepitoTratado ,

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