Forum Discussion

MichelBrown's avatar
MichelBrown
Regular Visitor
4 years ago
Solved

DAX formula weighted average support requested

Hello community, Can someone help me with a DAX formula to calculate average sales per store per period and per region as in the below example?   Even after reading many questions on the same topi...
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Assuming you're using dim_Regions[Region] in your visual, you should be able to define the ratio as:

    Sales per store =
DIVIDE (
    SUM ( fact_Sales[Sale] );
    SUM ( dim_Regions[Number of stores] );
    0
)
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Assuming you're using dim_Regions[Region] in your visual, you should be able to define the ratio as:

Sales per store =
DIVIDE (
    SUM ( fact_Sales[Sale] );
    SUM ( dim_Regions[Number of stores] );
    0
)