Forum Discussion
KPI Visual for new customers
Good morning/afternoon/night!
Consider the example from the table below:
| Week | Client |
| 1 | George |
| 1 | Clara |
| 1 | Julius |
| 2 | Clara |
| 2 | Julius |
| 2 | Homer |
| 3 | Homer |
| 3 | Clara |
| 3 | Jonas |
I need a measure that shows how many new clients (first appearence, only) past week and show the evolution through a KPI Visual like this one:
Plus, I need a drill through to see a table only with the new customers.
How can I do it?
2 Replies
- chonchar
Helper V
I might be able to help with the KPI card. Try this:
Caluclate(
DistinctCount(ClientNames, // whatever this column is called
DateADD(Calendar[date],-1, week
)
)
) - chonchar
The drill through is easy once you get that measure done. The KPI card needs to be done and so does the visual that you want to be drilled TO.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
Also,
