Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Christian ArltX]

I need a measure that sums all the max value_  per (group_) per (timestamp_) where type_ = “DailyActiveSubscriptionCount” && timestamp_ = Today()

Table = Statistic
Columns = type_, timestamp_, value_, group_
Notes = some group_ have multiple entries for the same timestamp_ with different value_ amounts  

——————————
Beau Arlt
Business Analyst
Holland MI
989-400-7812
——————————

[Hasham Niaz]

Hi Beau !

Please try following DAX;

MaxSubscription = 
VAR MaxDate = TODAY()

RETURN
    CALCULATE (
        SUM(Statistic[value_]),
        FILTER (
            ALLEXCEPT (Statistic, Statistic[group_], Statistic[timestamp_]),
            Statistic[type_] = "DailyActiveSubscriptionCount" && Statistic[timestamp_] = MaxDate )
    )

This will SUM [value_] based per [group_] & [timestamp_] WHERE [type_] = “” AND [timestamp_] = TODAY()

Regards,

——————————
Hasham Bin Niaz
Director Data & Analytics
Karachi, Pakistan
——————————
——————————————-

[Christian ArltX]

I need it to sum the max value. Let me know if you know how to do that as some days have multiple entries for the same group_

——————————
Beau Arlt
Business Analyst
Holland MI
989-400-7812
——————————
——————————————-

[Christian ArltX]

I figured out a solution

TotalSubs7DaysAgo:=CALCULATE(SUMX(VALUES(Statistic[group_] ),CALCULATE( MAX(Statistic[value_]))),filter(Statistic,Statistic[type_] = “DailyActiveSubscriptionCount” && Statistic[Short Date] = TODAY()-7))

——————————
Beau Arlt
Business Analyst
Holland MI
989-400-7812
——————————
——————————————-

[Hasham Niaz]

Nice, you get the idea of how to get MAX value per group than you can SUM those up.

Regards,

——————————
Hasham Bin Niaz
Director Data & Analytics
Karachi, Pakistan
——————————
——————————————-