Forum Discussion
Problem with Cell Elements Formatting
Hi MJG2112 , Thank you for reaching out to the Microsoft Community Forum.
Make sure the table visual includes a unique A key so the measure can evaluate per row. Then add this test measure to the visual, you should see 1 or 0 for each A row:
HasBFlag =
IF( CALCULATE( COUNTROWS( TableB ) ) > 0, 1, 0 )
Apply conditional formatting. Conditional formatting -> Icons (or Background) -> Format style = Rules -> What field should we base this on? = HasBFlag -> Summarization = First. Create two rules: 1 => green icon, 0 => red icon. Don’t return BLANK(), use 0 for missing-B. If A->B filtering is unreliable, use the explicit key variant that matches A’s key to B’s key.
If the test measure still shows the same value for every row, paste the exact DAX you used and a screenshot of the table with the test measure visible and anything you may feel relevant to the issue.
amitchandak I think I might not be explaining very well. I already have rule based formatting as you can see. It's based on the column being formatted, which is from Table A and is not blank or null. It has 'Yes' and 'No' values. The problem is it's not being applied to those rows that don't have a record in Table B. I would expect the Level OK column on the second row and bottom 2 rows in the other screenshoot to have the icon displayed.