Forum Discussion

Damian88's avatar
Damian88
Frequent Visitor
3 years ago
Solved

Dynamic Data Table to store calculation

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

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.