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.
I'm struggling to find solution: I have data on 1 row (company, product). I am wanting to pick a product and show all the companies that have NOT bought this product. I also only want to see the companies that have sold 2 or more products.
Data:
Company A Product 1
Company A Product 2
Company A Product 3
Company B Product 2
Company C Product 2
Company C Product 3
Company D Product 2
Company D Product 3
Result needed: I want to be able to select a product ( Product 1) and see list of companies that could still be sold Product 1:
Company C
Company D
I don't want to see Company B because it hasn't been sold 2 or more products.
I then would also like to count how many companies that I could sell Product 1 to, which would be 2.
Solved! Go to Solution.
You may take a look at the posts below.
You may take a look at the posts below.
@Sha ,
One way to get if you have company Dimension
Except(Company[Company],table[Company])
Other is create a measure and then use nest two measures for your two requirements
measure = count(Table[Product])+0
Filter measure =calculate(sumx(value(company[company]),[measure]),filter(Table,[measure]=0))
Filter measure 2 =calculate(sumx(value(company[company]),[measure]),filter(Table,[measure]>=2))
I created 2 measures but Value didn't work in 2nd measure, should I be using Values? It didn't produce any results.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |