Convert SQL query to DAX Command

[craghubi2020]

Hello,

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

select count(*) from table1
where column1 < 0.6

Thanks

Raghu

[craghubi2020]

@amitchandak .

Also, I was trying on the below sql query with DAX command but it seems to be invalid. can you please help me to find mistake in the below DAX.

countrows(filter(NvmWritingsInkUsage,NvmWritingsInkUsage[nvm_life]>.6 and <.8)).

select count(*) from table1
where column1 > 0.6 and column1 < 0.8

[amitchandak · Accepted solution]

@craghubi2020 , 

countrows(filter(NvmWritingsInkUsage,NvmWritingsInkUsage[nvm_life]>.6 && NvmWritingsInkUsage[nvm_life] <.8))

[amitchandak]

@craghubi2020 ,

Try a measure

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

Or a measure like

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

[craghubi2020]

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

Thanks

Raghu