topic Re: SQL Query to DAX Command in DAX Commands and Tips

SQL Query to DAX Command

raghukumarch — Fri, 12 Mar 2021 08:38:43 GMT

Hello,

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

select count(*) from table1
where column1 < 0.6

Thanks

Raghu

amitchandak — Fri, 12 Mar 2021 09:12:11 GMT

Try a measure

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

Or a measure like

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

raghukumarch — Fri, 12 Mar 2021 10:16:45 GMT

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