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 have table named company and i have product id ,sales amount and month column, i need unique product ids from every month where sales amount less than 100 ,Pls suggest dax
Product id not getting into dax in second dax,, find my table below
PR ID | Sales AMT | Month |
1 | 94 | 01-Apr-22 |
2 | 73 | 02-May-22 |
3 | 69 | 02-Jun-22 |
4 | 111 | 03-Jul-22 |
5 | 56 | 03-Aug-22 |
6 | 60 | 03-Sep-22 |
1 | 115 | 04-Oct-22 |
2 | 84 | 04-Nov-22 |
3 | 100 | 05-Dec-22 |
4 | 51 | 05-Jan-23 |
4 | 76 | 03-May-22 |
5 | 84 | 03-Jun-22 |
6 | 100 | 05-Jul-22 |
1 | 51 | 09-Aug-22 |
1 | 100 | 08-Sep-22 |
1 | 102 | 06-Oct-22 |
Hi , try these , change the source of table and column names
= DISTINCTCOUNTX( FILTER( company, company[sales amount] < 100 ), company[product id] )
Or try to use this :
= DISTINCTCOUNTX( FILTER( company, company[sales amount] < 100 && company[month] = "January" ), company[product id] )
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |