Help with calculating average measured subtotals

[Syndicate_Admin]

Good afternoon.

I need a help, which I have not given how to calculate these averages in the image table.

1 - OTIF MP suppliers	84%
2 - OTIF suppliers ME - Line	86%
3 - OTIF suppliers ME - Special	84%
4 - OTIF suppliers RE Stock imported	96%
5 - OTIF suppliers RE Stock national	82%
6 - OTIF Non Stock Suppliers	80%
7 - OTIF suppliers products and others	54%

The average should give me 81% but gives me 83%.

OTIF Supplier (%) =
Var xComply = [OTIF Supplier (Complies)]
Var xNoCumple = [OTIF Supplier (Not Compliant)]
Var xIndicator = DIVIDE(xCompupe,[Total],0)
RETURN
IF(xComply > 0,ROUND(xIndicator,2),IF(xNoComply>0,0))

OTIF Proveedor_AñoAnterior =
var xYearAnt = MAX ( 'Calendar'[Year] )-1
var xUpdate = [OTIF Provider (%)]
RETURN
IF(NOT(ISBLANK(xCurrent)),
CALCULATE ([OTIF Provider (%)],DATESYTD(Calendar[Year]-1

I need this measure to average me the average 81% which is the real not that 83%

OTIF Supplier *Base Point (%) =
var xUpdate = [OTIF Provider (%)]
var xIndicator = SELECTEDVALUE(Dim_OTIF[OTIF Proveedor_Indicador])
RETURN
IF(NOT(ISBLANK(xCurrent)),
CALCULATE(AVERAGEX(Dim_OTIF,Dim_OTIF[OTIF Provider *Base Point (#)]),
Dim_OTIF[OTIF Provider *Base Point (#)] <> BLANK(),
ALLEXCEPT(Dim_OTIF,Dim_OTIF[OTIF Proveedor_Indicador])))

Agardezco a lot

Thank you

[Icey · Accepted solution]

Hi @AOHORQUEZ ,

How about this? 

OTIF Supplier *Base Point (%) =
VAR xUpdate = [OTIF Provider (%)]
VAR xIndicator =
    SELECTEDVALUE ( Dim_OTIF[OTIF Proveedor_Indicador] )
RETURN
    IF (
        NOT ( ISBLANK ( xCurrent ) ),
        AVERAGEX (
            FILTER (
                ALLEXCEPT ( Dim_OTIF, Dim_OTIF[OTIF Proveedor_Indicador] ),
                Dim_OTIF[OTIF Provider *Base Point (#)] <> BLANK ()
            ),
            Dim_OTIF[OTIF Provider *Base Point (#)]
        )
    )

If this doesn't work, could you share me a sample .pbix file for test?

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.