unique ids calc from dax

[Anonymous]

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

[Anonymous]

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

[bhelou]

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] )