79135497

Date: 2024-10-29 00:52:44
Score: 0.5
Natty:
Report link

you can create a table for selection

Table 2 = DISTINCT('Table'[Class])

Do not create relationship between two tables.

Then create a measure

MEASURE =
IF (
    MAX ( 'Table'[Year] ) = MAX ( 'year'[Year] )
        && MAX ( 'Table'[Month] ) < MAX ( 'month'[Month] )
        && MAX ( 'Table'[Type] ) <> "C",
    1
)

add this measure to one visual filter and set to 1 enter image description here

You will see the selected type.

add this measure to another table visual filter and set to 0

enter image description here

then you can see the unselected type

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
Posted by: Ryan