Forum Discussion
Status Card
I built a dummy table and loaded it. Then I added a calculated column to tell if each line had breached the threshold
Then I wrote a measure to count all the 1's
I used 2 different tactics. One was to use a calculated column, because i needed access to a row context to easily calculated whether a row had exceeded or not.
The other was to use a measure, because i needed to use Calculate and All to reset the filter context so my count would count all the rows in the table, regardless of whether or not a user had clicked on one of the rows in the interface.
I built a dummy table and loaded it. Then I added a calculated column to tell if each line had breached the threshold
Then I wrote a measure to count all the 1's
I used 2 different tactics. One was to use a calculated column, because i needed access to a row context to easily calculated whether a row had exceeded or not.
The other was to use a measure, because i needed to use Calculate and All to reset the filter context so my count would count all the rows in the table, regardless of whether or not a user had clicked on one of the rows in the interface.
Hi kentyler ,
I forgot to mention, the threshold values are actually getting picked from a diffrent table. So the measure is like -
IF(Assessments(latest assessment)<Threshold(Threshold),0,1).
So I am unable to create this calculated column.