Hello,
I have a Matrix which has a Measure that calculates a value at both the Parent and Child levels:
| Record ID | Title (calculated via Measure) |
| Record A (Parent) | Title A |
| Record A expanded to show: Record B (Child) | Title B |
| Record B (Parent) | Title B |
In the Matrix, the Title is being reflected as expected, both for the Parent and Child records. But, if I apply a filter where Title = Title B, only Record A is returned. Record B at the Parent level is not listed. It seems the Measure filter is only being applied to the Child levels.
Measure:
Title =
SWITCH(
TRUE(),
ISINSCOPE('Parent + Child Table'[CHILD ID]) && MAX('Parent + Child Table'[CHILD ID])<>BLANK(),
CALCULATE(
MAX('Attributes Table'[TITLE]),
TREATAS(VALUES('Parent + Child Table'[CHILD ID]),'Attributes Table'[PARENT ID]),
ALLCROSSFILTERED('Attributes Table')
),
NOT ISINSCOPE('Parent + Child Table'[CHILD ID]),
CALCULATE(
MAX('Attributes Table'[TITLE]),
TREATAS(VALUES('Parent + Child Table'[PARENT_ID]),'Attributes Table'[PARENT ID]),
ALL('Parent + Child Table'[PARENT ID])
))
Any help is GREATLY appreciated.
