SQL Query to DAX Command

[raghukumarch]

Hello,

Could you please help in converting the below sql into DAX.

select count(*) from table1
where column1 < 0.6

Thanks

Raghu

[raghukumarch]

@amitchandak Thanks for quick response. this command is working. I'm need to validate with the data with business. I will let you know.

Thanks

Raghu

[amitchandak]

@raghukumarch ,

Try a measure

countx(filter(Table1,Table[column1]<.6), Table[column1])

Or a measure like

countrows(filter(Table1,Table[column1]<.6))