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.
Hi, I have a requirement that I am having trouble wrapping my mind around even though it is probably simple.
I have a table called SalesData. It contains various attributes about a sale and below is a simplified example of the data.
We would like to create the following measures based on this data and then filter this to a SalesRep level.
-Invoices with 1 item sold
-Invoices with 2 items sold
-Invoices with 3 items sold
-Invoieces with 4+ items sold
So just to be clear, this isn't the average (i.e. Total products/Total unique invoices created) - this needs to be a count of the number of instances the above conditions are met.
Any ideas?
Hi @jakeryan56,
Have you solved your probelm?
If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your desired output so that we could help further on it.
Best Regards,
Cherry
Hi,
Try this measure
Invoices with 1 item sold = COUNTROWS(FILTER(SUMMARIZE(VALUES(Sales_Data[Invoice]),[Invoice],"ABCD",COUNTA(Sales_Data[Description])),[ABCD]=1))
Just change the filter condition to 2,3 etc. for computing other measures.
Hope this helps.
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 |