Forum Discussion

sgsukumaran's avatar
sgsukumaran
Resolver II
7 years ago
Solved

Average Calculation

  I am trying to calulate ratio based on unique values on another column.  Eventually I want to sum the offset only based on unique "pick ticket contol number" and divide it by discount count of  "p...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi sgsukumaran,

     

    Try this formula, please. If it doesn't work, please share a dummy sample file.

    Warehouse Processing % =
DIVIDE (
    CALCULATE (
        SUMX (
            SUMMARIZE (
                Orders,
                Orders[Pick Ticket Control Number],
                Orders[Warehouse Processing Offset]
            ),
            [Warehouse Processing Offset]
        ),
        ALL ( Orders )
    ),
    CALCULATE (
        DISTINCTCOUNT ( Orders[Pick Ticket Control Number] ),
        ALL ( Orders )
    ),
    0
)

    Average_Calculation

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi sgsukumaran,

 

Try this formula, please. If it doesn't work, please share a dummy sample file.

Warehouse Processing % =
DIVIDE (
    CALCULATE (
        SUMX (
            SUMMARIZE (
                Orders,
                Orders[Pick Ticket Control Number],
                Orders[Warehouse Processing Offset]
            ),
            [Warehouse Processing Offset]
        ),
        ALL ( Orders )
    ),
    CALCULATE (
        DISTINCTCOUNT ( Orders[Pick Ticket Control Number] ),
        ALL ( Orders )
    ),
    0
)

Average_Calculation

 

Best Regards,

Dale