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 )
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]
)
)
)
This works fine. However when i use slice then it display incorrect count because there is know relationships between the tables.
Can you please solve this issue?
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