Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to list for a specific sales territory every customer record that we have along with those customers QTD Sales.
QTD Net Sales = TOTALQTD([Net Sales], 'Date'[Date])
When I add the above measure to my table visual, any customer without a record of sale in this time frame is excluded from the list. How can I circumvent this?
The goal here is to show what customers have yet to be called/contacted in the current quarter, showing us where there could be opportunity.
The columns in the table are as follows:
CustomerID, Customer Name, QTD Sales, LQTD Sales, QTD Variance, QTD Variance %
Filter by Sales Territory
Sales Table: Customer ID, Customer Name
Territory Table: Sales Territory. This is connected to the sales talbe by the territory field (one to many).
Thanks so much!
Solved! Go to Solution.
on your customer ID, please check the show items with no data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |