Hello, forgive me if this is a stupid question, but I cannot find examples about this.
I have a table chart used to display the customers that visited my site. I have a measure "VisitCount" and if I filter my calendar I see only those customers that visited my site in that particular date range. This is perfect.
I have also a visit YTD measure, that counts all the visit of the year, not considering the selected period.
My goal is to show "customer", "visit count" (for example this week) and "YTD visit count". The undesired effect is that the inclusion of the YTD measure causes the table to show all the customers that have a visit this year. I want to show only customer of the period, but for each customer I want to show also the YTD count.
I can't find any way to achieve this but I think it should be a very common use case, so I'm sure there is a simple solution.
I don't want to see customers that have 0 in the first measure.
Uhm.. why? The measure is fine. I want the total lifetime value of the visit count, and this work.
But this measure forces the table to show every customer that have a non zero value for this lifetime value.
I try to explain in a different way: This week I have 100 distinct customers that visited my site. I want the table to show those 100 customers.
Everything very simple, but now I want for each customer, to include the total visit count, but only for those 100 customers of the week. If I put the total measure in a new column, the table shows thousands of customers and not the 100 of the week.