Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have built a table to pull Account, Order Date, Customer name, and Product Purchased. It works PERFECTLY when I create a use the COUNT(customerid ) as my value. But when I create a measure to do the same thing, everything counts exactly the same but it lists ALL products, not just the ones on that specific order! Below are screen shots of the before and after using a measure as well as the measure itself.
Any additional filter on the measure that would only find the products listed on the Order Products table?
Thanks in advance,
DAX:
Solved! Go to Solution.
This was really helpful with a slight modification...I ended up using the COUNTA but put it on the Order_Products data table instead of the 'Order' Table and it was able to start counting each product on an order (which is really what I wanted to get to anyway.
Thank you for your help!!
Are you able to share a demo pbix file or some example data from the underlying tables? Hard to diagnose without that but you might try:
New In Practice Signup =
CALCULATE (
COUNTROWS ( 'Order' ),
'Order'[New Subscription vs Renewal] = "New ARP In Practice"
)
This was really helpful with a slight modification...I ended up using the COUNTA but put it on the Order_Products data table instead of the 'Order' Table and it was able to start counting each product on an order (which is really what I wanted to get to anyway.
Thank you for your help!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |