Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sam01
Frequent Visitor

Getting Standard Deviation on counts if ID rolled off at month level

Hello Power BI team,

 

I am trying to get Standard deviation based on monthly count but running into issues. I was not able to use biult in function STDEV but did not work wondering if anyone was able to calculate Standard deviation on scenario shown an in attached .pbix? 

https://1drv.ms/u/s!Ak_CUb7-a3wXakVfzU08cCNSHBE

TIA

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Sam01 

What about something like this:

Standard Deviation Attempt = 
    STDEVX.P(
        ADDCOLUMNS( 
            SUMMARIZE( 
                'Fact', 
                DimDate1[Month],
                DimName[Name]
            ), 
        "Count", 
        [ActualCount]
        ),
        [ActualCount]
    )

 

Std Dev.png

 

View solution in original post

6 REPLIES 6
sajidtp
Frequent Visitor

Hi Sam, this worked for my scenario recently using Matt Ellington's solution: 

Monthly Standard Deviation with Calendar = CALCULATE(
STDEVX.P('DimDate1',
[Monthly Avg]),
ALL('DimDate1'[Month])
Sam01
Frequent Visitor

@sajidtp  Hi thanks for your relpy, following measure is returning  0.41 as standard deviation but in actual it should be 5.9, any thoughts?

sajidtp
Frequent Visitor

Hi @Sam01 negative, newbie to Std. Dev. as well... still learning...

Anonymous
Not applicable

@Sam01 

What about something like this:

Standard Deviation Attempt = 
    STDEVX.P(
        ADDCOLUMNS( 
            SUMMARIZE( 
                'Fact', 
                DimDate1[Month],
                DimName[Name]
            ), 
        "Count", 
        [ActualCount]
        ),
        [ActualCount]
    )

 

Std Dev.png

 

Thank you @Anonymous this is awesome! 

@Anonymous  Perfect, thank you so much.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.