Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
4 years ago
Solved

Avg Fill rate

Hi All,
I want to find The AVG Fill rate for customers and Warehouse separately

Here is am attaching sample Screenshots of both 

And I attached the data as well.
I need avg fill rate for customer fill rate % and AVG Fill rate % for Ware house separately 
Pls help me to create this Dax
Thanks 
Alan 


Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    AlanP514 , based on what I got

    try like

     

    Customer
    AverageX(values(table[Customer]), calculate(Average([fill Rate])) )

    or

    AverageX(values(table[Customer]), calculate(Max([fill Rate])) )

     

    Warehouse

     

    AverageX(values(table[Warehouse]), calculate(Average([fill Rate])) )

    or

    AverageX(values(table[Warehouse]), calculate(Max([fill Rate])) )

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    AlanP514 , based on what I got

    try like

     

    Customer
    AverageX(values(table[Customer]), calculate(Average([fill Rate])) )

    or

    AverageX(values(table[Customer]), calculate(Max([fill Rate])) )

     

    Warehouse

     

    AverageX(values(table[Warehouse]), calculate(Average([fill Rate])) )

    or

    AverageX(values(table[Warehouse]), calculate(Max([fill Rate])) )