Standard Deviation for Unique Values in a Column rather than rowcount

[tt_london]

How can I create a standard deviation for the unique values in a column? The built-in formula calculates it per row number.

Sample dataset

Business Date	Revenue
01/01/2024	100
01/01/2024	200
02/01/2024	150

In this case N = 2, not 3.

[ahadkarimi · Accepted solution]

Hi @tt_london, try calculated table and two measures below, and if you encounter any issues, let me know.

Create a calculated table:

UniqueBusinessDates = DISTINCT('Table'[Business Date])

Create a measure:

RevenueForUniqueDates = 
SUMX(
    'UniqueBusinessDates',
    CALCULATE(SUM('Table'[Revenue]))
)

Create a measure again:

StdDevUniqueRevenue = 
STDEVX.P(
    'UniqueBusinessDates',
    CALCULATE(SUM('Table'[Revenue]))
)

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Supplier!

[tt_london]

Instead of creating a table, can I use the Unique Days Measure I created before?

Unique Days = DISTINCTCOUNT(PNL[Business Date])

If yes, how can I adjust your code accordingly?