Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
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.
User | Count |
---|---|
84 | |
71 | |
71 | |
67 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |