Good! Of course, I leave below how is the structure:
Stalemate:
- Informed Roadmap
- Royal visits
- Clients
- Sell Out
- Sellers
- Calendar
Based on these tables, in a report I detailed the contrast of the roadmap vs the actual visits (here I visualize who was actually visited).
Then on another page what I did to see who were NOT visited was to make a measurement calculating this: "Total customers s / visit" = DISTINCTCOUNT (Customers "Client") - DISTINTCOUNT (Real Visits "Client"), here what I get is the number of customers who were not visited then allows me to make a subtraction between the distinctive count of both and gives me the number of customers not visited. I show this by adding 2 cards with the first 2 values mentioned and another card putting the difference between the two to contrast.
This value as a result of the subtraction of these 2 values what I did was convert it to text (String): "Clients s / visit" = CONVERT(<Total clients s / visit>, ) taking the values that interest me with the number 1. I do this to be able to make under the cards a detail with the data of the customers who were not visited. With the table visualization I put Customer data and add the filter "Clients s / visit" taking the values 1 to obtain only those that were not visited and I am armed with the detail perfectly.
I made the same table but with sales, taking the net of the Sell Out table and adding in the same way that filter so that in a column it shows me how much that client bought without having visited it and here is the problem; I want to be able to have this net worth in one measure, to be able to divide it with the overall sales total and get a percentage of the total, allowing each time I select a customer to show me the corresponding individual value with the percentage of participation in the total sale.
That would be the methodology of the report, I hope I have been clear!
