Forum Discussion

BdC2's avatar
BdC2
New Member
1 year ago
Solved

Problem with Average

I am quite new to PowerBI and really struggling with something I feel should be quite simple... Average... I have a set of data that has location, product name, Qty and Data Week. The normal Average...
Need Help
Show and Tell
  • BdC2's avatar
    BdC2
    1 year ago

    The solution that ended up working for my set of data was:

     

    TotalQtyPerWeek = 

    CALCULATE(

    SUM('Table'[Qty on Hand]),

    ALLEXCEPT('Table','Table'[Location],'Table'[Date Week],'Table'[Product Name])

    )

     

    WeeksCount = 

    CALCULATE(

    DISTINCTCOUNT('Table'[Data Week]),

    ALLEXCEPT('Tabke','Table'[Location],'Table'[Product Name])

    )

     

    AverageQtyPerWeek =
    DIVIDE(
    [TotalQtyPerWeek],
    [WeeksCount]
    )

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi BdC2 ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

If this is the solution that has worked for you please accept your reply as solution so as to help other community members who may face similar issue in the future

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

 

BdC2's avatar
BdC2
New Member
1 year ago

The solution that ended up working for my set of data was:

 

TotalQtyPerWeek = 

CALCULATE(

SUM('Table'[Qty on Hand]),

ALLEXCEPT('Table','Table'[Location],'Table'[Date Week],'Table'[Product Name])

)

 

WeeksCount = 

CALCULATE(

DISTINCTCOUNT('Table'[Data Week]),

ALLEXCEPT('Tabke','Table'[Location],'Table'[Product Name])

)

 

AverageQtyPerWeek =
DIVIDE(
[TotalQtyPerWeek],
[WeeksCount]
)