Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
Could you please help in converting the below sql into DAX command.
select count(*) from table1
where column1 < 0.6
Thanks
Raghu
Solved! Go to Solution.
countrows(filter(NvmWritingsInkUsage,NvmWritingsInkUsage[nvm_life]>.6 && NvmWritingsInkUsage[nvm_life] <.8))
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
countrows(filter(NvmWritingsInkUsage,NvmWritingsInkUsage[nvm_life]>.6 && NvmWritingsInkUsage[nvm_life] <.8))
Try a measure
countx(filter(Table1,Table[column1]<.6), Table[column1])
Or a measure like
countrows(filter(Table1,Table[column1]<.6))
@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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |