Standard Deviation for Unique Values in a Column rather than rowcount

Hi Anonymous, 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!