Forum Discussion

SoftDev's avatar
SoftDev
Regular Visitor
3 years ago

Display parent data field when child is blank

Hello!   I want to create a dynamic filter where I can display by default only Business applications where Properties_System is not null, but by changing other filter show only Business application...
General Comment
v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi SoftDev ,

 

Based on your description, I have created a simple sample:

Please try:

Measure =
VAR _a =
    SUMMARIZE (
        FILTER ( ALL ( 'appEvents TEST' ), [ID] = MAX ( 'recources TEST'[ID] ) ),
        [Properties_System]
    )
VAR _b =
    MINX ( _a, [Properties_System] )
RETURN
    SWITCH (
        TRUE (),
        _b <> BLANK ()
            && NOT ( ISFILTERED ( 'Status table'[Status] ) ), 1,
        _b = BLANK ()
            && ISFILTERED ( 'Status table'[Status] ), 1
    )

Apply it to the visual level filter:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

SoftDev's avatar
SoftDev
Regular Visitor
3 years ago

Thank you for trying to help! 👍

This doesn't work, returns only two values and both has valid relations, maybe because id's are TEXT.

 

And I forgot to mention, this has to be dynamic by selected period of dates from appEvents TEST table.

 

Probably would solve the problem if I could select that option separatly for each field. Example:

 

If I remove Properties_System field everything works and if I add this to Matrix table with values from appEvents, also displays correctly, but cannot apply Status filter. 

 

Logic is to when Inactive is selected display all values from recources TEST wich don't have any relation from table appEvents TEST for the selected time period.

When Active is selected display all relations

When All onboarded display both