[Muhammad Akhtar]

Hi need HELP!!

 

When I execute a command in Tabular model I get the follwoing numbers

Sum of present Studnets  161 

Sum of all enrolled 278

 

I execute the DAX formula ( i grabbed it using the profiler ) it shows me 

 

Sum of present Studnets  171 

Sum of all enrolled 315

 

My DAX formula is:

 

EVALUATE
CALCULATETABLE(
ADDCOLUMNS(
KEEPFILTERS(
SAMPLE(
3502,
FILTER(
KEEPFILTERS(VALUES(‘StudentAttendanceData'[AttendanceDate])),
OR(
NOT(
ISBLANK(CALCULATE(SUM(‘StudentAttendanceData'[All Enrolled])))
),
NOT(
ISBLANK(CALCULATE(SUM(‘StudentAttendanceData'[Present Students])))
)
)
),
‘StudentAttendanceData'[AttendanceDate],
1
)
),
“SumAll_Enrolled”, CALCULATE(SUM(‘StudentAttendanceData'[All Enrolled])),
“SumPresent_Students”, CALCULATE(SUM(‘StudentAttendanceData'[Present Students]))
),

KEEPFILTERS(
FILTER(
KEEPFILTERS(VALUES(‘StudentAttendanceData'[AttendanceDate])),
AND(
‘StudentAttendanceData'[AttendanceDate] >= DATE(2016, 10, 10),
‘StudentAttendanceData'[AttendanceDate] < DATE(2016, 10, 11)
)
)
)
)

ORDER BY
‘StudentAttendanceData'[AttendanceDate]

 

Any help will be gretaly appreciated.

Thanks,

Roomi