Forum Discussion
Conditional Formatting Between Tables
I can't give you an answer without seeing the entire model and measures. But in principle, the table at the bottom looks like it is filtered by student and course to generate the response (conditional formatting). But of course those 2 items are coming from 2 tables. If you want colour conditional formatting in the top table, you will need to embed the course filtering inside a measure. You could do that with an X function. This is illustrative only as I don't know your model.
=MAXX(courses,IF([measure that returns course pass]=FALSE(),1,0))
the above measure will cycle through all courses for a student and return 1 if there is at least 1 fail and 0 if there are no fails. You could change it to SUMX instead and that would return the number of fails. This could be used to show relative performance of students. Hth
Community ChampionI can't give you an answer without seeing the entire model and measures. But in principle, the table at the bottom looks like it is filtered by student and course to generate the response (conditional formatting). But of course those 2 items are coming from 2 tables. If you want colour conditional formatting in the top table, you will need to embed the course filtering inside a measure. You could do that with an X function. This is illustrative only as I don't know your model.
=MAXX(courses,IF([measure that returns course pass]=FALSE(),1,0))
the above measure will cycle through all courses for a student and return 1 if there is at least 1 fail and 0 if there are no fails. You could change it to SUMX instead and that would return the number of fails. This could be used to show relative performance of students. Hth