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

[Christian ArltX]

I have a table (OperationLog) of transactions by CustomerId. I need to figure out the total transactions for each CustomerId and then the average of all the (totals from each customer) in one Dax formula.

My hope is to use my linked date table (In Power BI) to see a month view of the overall average number of transactions based on different levels (Year and Month Mostly).

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

[Lorenzo Vercellati]

HI,
you need a measure like this one:

Measure =
AVERAGEX(

SUMMARIZE(

OperationLog,

‘OperationLog'[CustomerID],

“Transaction count”,

COUNTROWS(OperationLog)

),

[Transaction count]

)

Regards
Lorenzo

——————————
Lorenzo Vercellati
PowerBI Solution Architect
SolidQ
Milan
3382819866
——————————
——————————————-

[Christian ArltX]

Hi Lorenzo – I’m going to send you some test data, the dax you submitted..does work.. but appears to not be giving me the correct value. Can you test too? Thanks!

I need to figure out the total transactions for each CustomerId and then the average of all the (totals from each customer) in one Dax formula.
Filters:Date, Product

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

[Christian ArltX]

I got it. Once I took out the 0 counts from the months summary sections… it worked perfectly

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

[Lorenzo Vercellati]

Well done!

——————————
Lorenzo Vercellati
PowerBI Solution Architect
SolidQ
Milan
3382819866
——————————
——————————————-