Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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
    9 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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello all together,  

i habe a Problem with Ma Chart as you can see below.

The average is Not exactly on  top of the Distribution. 
What do you think is the Problem?

Thanks in advance