Dynamic Data Table to store calculation

[Damian88]

Hi,

I want to create Dynamic Table that will be a source for Chart (if its possible to create chart without creating seperate table is even better)

I need to create chart with info how many unique Customers were wisited X times  (1 time,2 times, 3 Times etc)

It should be possible to filter period or other components

I thout that there is option to create supporting dinamic Table that will count number of distinct "Interaction ID" for distinct "customer" as bellow  -there is one customets that have 4 unique Interaction ID (C4) 

I was able to create such column in current data table but changing filters does not relaculate results (because they are not related with date) so maybe supportin table will hepl

I will be werry gratefull for some tips

Thnx

[v-rzhou-msft · Accepted solution]

Hi @Damian88 ,

I suggest you to create a dimcountdate table firstly and then create a count customer measure.

Dynamic Day = 
VAR _SUMMARIZE = SUMMARIZE(ALL('Table'),'Table'[Customer],"CountDate",COUNT('Table'[Date]))
RETURN
GENERATESERIES(1,MAXX(_SUMMARIZE,[CountDate])+1)

Measure:

Count Customer = 
VAR _SUMMARIZE = SUMMARIZE('Table','Table'[Customer],"CountDate",COUNT('Table'[Date]))
return
COUNTAX(FILTER(_SUMMARIZE,[CountDate] = MAX('Dynamic Day'[Count Date])),[Customer]) + 0

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.