Forum Discussion
Matrix cell markers complex logic for display works except on 2 of my rows.
MAX didn't change the outcome but I finally figured out the error... It was ultimately due to a realtionship to the KPI_ID but it was further upstream in one of the measures. I ended up having to change a few measures and rework my source SQL because those two rows would never have worked because they were coming from an table that could not be related to the KPI_Name.
Community Championbrettgrubbs Difficult to know what exactly is going wrong there. You might try using MAX instead of SELECTEDVALUE. SELECTEDVALUE returns blank by default if there are more than one values in context.
MAX didn't change the outcome but I finally figured out the error... It was ultimately due to a realtionship to the KPI_ID but it was further upstream in one of the measures. I ended up having to change a few measures and rework my source SQL because those two rows would never have worked because they were coming from an table that could not be related to the KPI_Name.