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 everyone,
I have a table of customers with invoice date like the following:
Customer Number | Invoice Date |
123 | 11/18/2020 |
123 | 11/17/2020 |
123 | 11/16/2020 |
124 | 11/16/2020 |
124 | 11/15/2020 |
125 | 11/16/2020 |
I'm trying to summrize the table to have the distinct customer number who have 3 or more invoices, I tried the following dax code but it returning the whole list of customers without in filtering, it should return a list of only one customer which is "123".
Table = SUMMARIZE(FILTER('Customer Invoices',DISTINCTCOUNT('Customer Invoices'[Invoice Date])>=3),'Customer Invoices'[Customer Number])
Solved! Go to Solution.
Please use this expression instead
Table 2 =
FILTER (
DISTINCT ( 'Customer Invoices'[Customer Number] ),
CALCULATE (
COUNT ( 'Customer Invoices'[Invoice Date] )
) >= 3
)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi,
You may download my PBI file from here.
Hope this helps.
Please use this expression instead
Table 2 =
FILTER (
DISTINCT ( 'Customer Invoices'[Customer Number] ),
CALCULATE (
COUNT ( 'Customer Invoices'[Invoice Date] )
) >= 3
)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks it works!
Though I have a quiestion can I insert a filter to just return the October distinct values for example like this filter month(invoice Date)=10?
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |