Forum Discussion
SQL to DAX conversion
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 )
Getting following error:
A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression.This is not allowed.
There is a twist. Gap is not a column in the table,its a measure that i have created.
Suppose Attendee name 'John' have attended 3 meeting then there will be 3 rows in database table for 'John'.
There is predefined value which define how many meetings everyone should attend for ex. 5.
So for 'John' gap would be 2.
Like wise for other attendee.
There is a twist.Gap is not a column in the table,Its a measure that i have calculated.
Suppose attendee 'John' have attended 3 meeting then there will be 3 rows in database table for 'john'.
There is predefined number of meeting that every attendee should attend for ex. 5 which i stored in different measure.
So Gap for John will be 5-3=2. Like wise for other attendee.