What is the average of transactions by location per day

[Anonymous]

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

[Anonymous]

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

[vapid128 · Accepted solution]

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]