topic What is the average of transactions by location per day in DAX Commands and Tips

What is the average of transactions by location per day

Anonymous — Tue, 19 Jul 2022 16:43:14 GMT

Hi,

My formula doesn't work.

SDR ID average per CP ID average per Day =

AVERAGEX(

KEEPFILTERS(VALUES('FACT TABLE'[Start Date].[Day])),

CALCULATE([SDR ID average per CP ID])

)

SDR ID = Unique transaction numbers
CP ID = Location Unit number

I need to calculate the average of SDR ID per CP ID per Day.
In summary how many times my CP ID was used per day based on the unique SDR ID.

My columns:
FACT TABLE[SDR ID]
FACT TABLE[CP ID]

FACT TABLE[Start Date]
FACT TABLE[Site]

Please someone assist.
Many thanks

Re: What is the average of transactions by location per day

vapid128 — Tue, 19 Jul 2022 17:51:43 GMT

emmmmmm

TRY

AVERAGEX(

VALUES('FACT TABLE'[Start Date]),

CALCULATE([SDR ID average per CP ID])

)

that is how i normally do it

i don get why you need to add keepfilter and .[day]

Re: What is the average of transactions by location per day

Anonymous — Wed, 20 Jul 2022 07:03:01 GMT

Wow! It worked! Amazing Thank you vapid128
Much appreciated. Great learing curve for me.
Best wishes, J