Display parent data field when child is blank

[SoftDev]

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 applications where Properties_System is null.

Table A(Business application) one to many table B(Properties_System)

Other filter with options like Active, Inactive and All.

Is it possible?

And how can I do it?

[v-jianboli-msft]

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]

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

[v-jianboli-msft]

Hi @SoftDev ,

What is your filter and what the source data looks like?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

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]

Hi!

Fields Table recources TEST(Business application) and table appEvents TEST(Properties_System) from both tables are in the same Business application data filter

And using this table for filtering Business application data filter wich makes it dynamic filter

Measures are used in data filter for Business application filter like: 

Filter status TEST = if(selectedvalue('Status table'[Status]) = "Active", if([Current message count TEST] > 0, 1, 0), if(SELECTEDVALUE('Status table'[Status]) = "Inactive", if(or([Current message count TEST] = 0, isblank([Current message count TEST])),1, 0),if(SELECTEDVALUE('Status table'[Status]) = "All onboarded",1)))

Problem is, when "Inactive" or "All onboarded" is selected, Business applications without relation in appEvents TEST table is not displayed.

Filtering:

Hope this explains better 🙂