Forum Discussion

PasiNiinikoski's avatar
PasiNiinikoski
Frequent Visitor
6 years ago

Calculating average with values more than x

I have this very simplified data sheet:   WorkerName Date ProductsMade John 2019/12/01 40 John 2019/12/01 50 John 2019/12/05 90 John 2019/12/05 70 John 2019/12/07 110 ...
DAX Calculation
Need Help
POWER BI Dax rules
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi PasiNiinikoski 

try a measure

Measure = CALCULATE(AVERAGE(Query[ProductsMade]);ALLEXCEPT(Query;Query[WorkerName]);Query[ProductsMade]>100)

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

PasiNiinikoski's avatar
PasiNiinikoski
Frequent Visitor
6 years ago

Hi az38 and thanks,

 

will try that but I must first somehow calculate the sum of the ProductsMade by worker per day and then apply that measure. 

 

-Pasi

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    PasiNiinikoski 

    ProductsMade = CALCULATE(SUM('Table'[Products]);ALLEXCEPT('Table';'Table'[WorkerName];'Table'[Date]))

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution