Forum Discussion
Solved
SQL to DAX conversion
Hello Experts, I am facing issue while converting below SQL query into DAX. Can you please help me to convert the query: SELECT COUNT(D.OperatingValue), C.StartTime, C.EndTime FROM C, D ...
Try this New Table from Modelling Tab
New Table = SUMMARIZE ( C, C[Start Time], C[End Time], "Count", CALCULATE ( COUNT ( D[Operating value] ), FILTER ( D, D[Operating value] <= 5 && D[Process Time] >= C[Start Time] && D[Process Time] <= C[End Time] ) ) )Another way
New Table2 = CALCULATETABLE ( SUMMARIZE ( C, C[Start Time], C[End Time], "Count", CALCULATE ( COUNT ( D[Operating value] ), FILTER ( D, D[Process Time] >= C[Start Time] && D[Process Time] <= C[End Time] ) ) ), D[Operating value] <= 5 )
Table have 20 rows and my table visualization display data only when Gap>=3(as given below) which i able to display on dashboard. Along with table visualization i wanted to display count of attendee who has Gap>=3 on Card visualization(Value should be 6) which i am unable to do.
Any help or idea is much appreciated.
| Attendee Name | Meetings | Gap |
| Claire Baker | 1 | 4 |
| Geneva Barnett | 1 | 4 |
| Johnnie Carpenter | 1 | 4 |
| Jonathan Goodwin | 1 | 4 |
| Marsha Robertson | 1 | 4 |
| Salvador Elliott | 1 | 4 |
Hi nish2288,
Create a following measure using DAX:
Count Of Attendee Gap gt 3 = CALCULATE(COUNT(TableName[Attendee Name]),TableName[Gap]>3)
After creating measure pull this measure on Card Visual. You will get your solution.
Regards,
Mayur