Forum Discussion
Conditional Measure
Anonymous
pls see the attachment below
Anonymous
could you pls provide the sample data and expected output?
Yes no problem
So I have a CSV with various marks entered in a register for students. I have then in a measure calculated the rows that have the present attendance marks against the possible to give me the percentage attendance. Based on the date range of the marks against the academic calendar would determine the column marks HT1, HT2, HT3 etc (these are the term names). There is a relationship between the two tables.
The students that have recieved 100% for the term should recieve 100pts. I then needs to do this by week so if there is a DAX i could just amend this to reflect the week rather than term.
HT1 %Present HT1 Pts HT2 %Present HT2 Pts Average% Total HT Pts 100.00% 100 95% 0 97.5% 100 98.47% 0 100% 100 50% 100 95.56% 0 100% 100 50% 100 So the outcome here is I need to a DAX to calculate if the Attendance % for HT1 = 100 then return the Value 100 is else then 0. What I need though is for the Term total and week total to be be returned in seperate columns/Measures that i could then add up at the end so kind of like a running total of points
yes just give me a few minutes its an anormous file so im just going to snap some of the data out thats anonomised
Anonymous
this is the expected output. Could you pls provide some sample data? maybe that CSV file?