Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Standard Deviation

Hi All, My Fact has ItemKey,CompanyKey,MonthKey,Revenue is there anway to calculate 'StDev.P' with resepect to itemnumbers from Item Dimension and MonthNumbers from Date Dimension. where revenue f...
Need Help
  • OwenAuger's avatar
    OwenAuger
    10 years ago

    Anonymous

     

    I would personally prefer to do this with a measure rather than creating any intermediate tables:

    Something like:

    =
STDEVX.P (
    SUMMARIZE ( 'Fact', DimItem[ItemNumber], DimDate[MonthNumber] ),
    CALCULATE ( SUM ( 'Fact'[Revenue] ) )
)

    This should produce the same result as Eric_Zhang had above.

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
10 years ago

Anonymous

 

I would personally prefer to do this with a measure rather than creating any intermediate tables:

Something like:

=
STDEVX.P (
    SUMMARIZE ( 'Fact', DimItem[ItemNumber], DimDate[MonthNumber] ),
    CALCULATE ( SUM ( 'Fact'[Revenue] ) )
)

This should produce the same result as Eric_Zhang had above.

srb803's avatar
srb803
Frequent Visitor
2 years ago

I am working on a similar scenario and have hierarchies of the categories. 
It worked for me at the top level.