How do I know the total number of purchased made (Frequency) by each customer ID?

[Anonymous]

I am trying to get the RFM.

What DAX formula should I use to get the Frequency?

[StefanoGrimaldi]

hey

you have 2 ways here

first: you could make a new table as follow: 

 table = summarize("table name", "Costumer id column","Frecuency",count("Costumer id column")

second:if you want it in the column as above you can try this them (this column would go in your original table, no need for a new table):

Column =

var value1 = 'Table'[costumer id]

var value2 = CALCULATE( COUNT('Table'[costumer id]),'Table'[costumer id]=value1)

return value2

notice adding a new column will make the value calculated for each row so you have to make sure when using that column to use a average of the value or dont summarize it in the visual to get the correct value, 

if this was of help let me know and luck 🙂 

[Anonymous]

Hi  Thanks Stefano! Seems to need a little more help here! 

[StefanoGrimaldi]

strange, it works fine for me, can you pass that table with garbage data if possible to check out where its that circula reference error at. 

[Anonymous · Accepted solution]

Hi Stefano,

I've managed to find a work around using 

Frequency = CALCULATE(DISTINCTCOUNT(Trans[RECEIPT_ID])).

Thanks anyway! 

Have a great day ahead 😃