Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help Making an advanced standard deviation with filter based on a column

Hi everyone, i need help with this problem: Look at this table: [Sales]   Click Here    And from that table i made this visual (The Standard Deviation value is 65.68)   The Standard Dev...
  • stevedep's avatar
    stevedep
    6 years ago

    Thanks, that helps. See solution below:

    stdevm = CALCULATE(STDEVX.P(VALUES(Sales[Seller Name]);CALCULATE(sum(Sales[Average Sales per Day]))))

    as seen here:

     

     

    See modified Power BI file here. 

     

    If this is what you are looking for, please mark as solution. Kudo's appreciated.

     

    Kind regards,

     

    Steve. 

stevedep's avatar
stevedep
Memorable Member
6 years ago

Thanks, that helps. See solution below:

stdevm = CALCULATE(STDEVX.P(VALUES(Sales[Seller Name]);CALCULATE(sum(Sales[Average Sales per Day]))))

as seen here:

 

 

See modified Power BI file here. 

 

If this is what you are looking for, please mark as solution. Kudo's appreciated.

 

Kind regards,

 

Steve. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Excelent!

 

Thank you both.