How to take the STD Deviation of 2 locations combined.

[CJ0323]

In my dataset I have a table that looks like this.

Location	Sale#	Shirts
A	1	$100
A	2	$225
A	3	$50
B	1	$125
B	2	$215
B	3	$75

 I want to take the STD deviation of several locations combined but I need a measure that will summarize the sale# for each instanc. For instance for Sale# 1 should be Location A+B ($100+125) then Sale# 2 should be (225+215) so on for how many ever sale# we have. Then after this combination/summarization we need to take the STDDEV. So it would look like this STDDEV( (225,440,125). How can I do this using measures? Keep in mind I will have a filter that will allow of 1 or multiple locations to be selected.

[v-tianyich-msft · Accepted solution]

Hi @CJ0323 ,

I made simple samples and you can check the results below:

Summarized Sales = SUMX(
    SUMMARIZE(
        'Table',
        'Table'[Sale#],
        "TotalSales", SUM('Table'[Shirts])
    ),
    [TotalSales]
)

STDDEV of Combined Sales = STDEVX.P(
    SUMMARIZE(
        'Table',
        'Table'[Sale#],
        "SummarizedSales", [Summarized Sales]
    ),
    [SummarizedSales]
)

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.