We are an intermediary and we sell products of different vendors to customers
We have orders table where vendor name, customer name, and other information related to orders is available
Requirement
We want the count of customers where we have sold 5 or more vendors. It means if we have sold products of 5 or more vendors to customer, want count of that customer, like how many are the customers meeting this criteria.
Workings Done.
I have tried to use calculate function but it is not showing any data.
Below is the DAX
CALCULATE([No. of Unique Customers],FILTER(History_OH,[Vendor Distinct Count]>=5))
Can any one please guide how to cater this requirement using DAX?
You can tackle this directly in Power Query by creating a new Reference Table from the Orders Table and using the Group By Function on Customer Column and Distinct Count on Vendor columns.
Hi @hasnainakram94 did the response provided by @pranamg help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.
Hi @hasnainakram94, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
