Need Help in finding Dependent table data

Question

Hi All,&nbsp;I have below columns in my dataset.table_name - T1,T2,T3..,tenant_name - A, B, C.. Unique values,Operation - Read, Write, OtherWave - Wave1, Wave2, Wave3, Wave4I want to find dependent tenants for suppose, My data is like below:&nbsp;WaveTenantTableOperationWave1&nbsp; &nbsp;ATab1READWave2&nbsp; &nbsp;BTab2WRITEWave3&nbsp; &nbsp;CTab3OTHERWave4&nbsp; &nbsp;DTab2READWave1&nbsp; &nbsp;ETab1WRITEWave3&nbsp; &nbsp;FTab8WRITEHere, I want to find dependent tenants. For example Tenant A is reading the table in wave 1 but same table was writing by Tenant E in Wave1. I want to mark this Tenant A has dependent.If table was reading and writing by one tenant, There is no other tenant using that table i want to mark it has Exclusive.I am expecting out put like below:TenantWave1Wave2Wave3Wave4A1000B0100C&nbsp;&nbsp;&nbsp;&nbsp;D&nbsp;&nbsp;&nbsp;&nbsp;E&nbsp;&nbsp;&nbsp;&nbsp;Here, Tenant A was dependent on 1 other tenants in wave1, Tenant A was not dependent on anyother tenant in Wave2.&nbsp;Any leads will be appriciated!Thanks in advance.&nbsp;Greg_Deckler&nbsp;amitchandak&nbsp;Ritaf1983&nbsp;lbendlin&nbsp;Ashish_Mathur&nbsp;#Need Help

sahir_maharaj · Answer

Hello&nbsp;Viswa11,
&nbsp;
Can you please try the following:
DependentCount = 
SUMX(
    FILTER(
        'YourTable', 
        'YourTable'[DependencyStatus] = "Dependent"
    ), 
    1
)

viswa11 · Answer

Hi&nbsp;Sahir_Maharaj&nbsp;,How can i find dependency table, I don't have any dependency column. For each individual operation I can do count and all but here I want to check is there any other tenant reading the table which was writting by other tenant then i want to mark has dependent table.I have tried something like below.Dependent =IF (&nbsp; &nbsp; 'Table'[Operation] = "WRITE",&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS ('Table'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Table',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Table'[Operation] &nbsp;= "READ"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; 'Table'[TENANT_NAME] &lt;&gt; EARLIER ('Table'[TENANT_NAME])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; 'Table'[TABLE_NAME] = EARLIER ('Table'[TABLE_NAME])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; ) &gt; 0,&nbsp; &nbsp; &nbsp; &nbsp; "Dependent",&nbsp; &nbsp; &nbsp; &nbsp; "Not Dependent"&nbsp; &nbsp; ),&nbsp; &nbsp; "Not Applicable")

Forum Discussion

Need Help in finding Dependent table data

2 Replies

Related content

Find Dependency of Fabric Warehouse Table

Circular dependency

Cannot find table

Dax query dependency

Circular dependency - Odd table

Wave	Tenant	Table	Operation
Wave1	A	Tab1	READ
Wave2	B	Tab2	WRITE
Wave3	C	Tab3	OTHER
Wave4	D	Tab2	READ
Wave1	E	Tab1	WRITE
Wave3	F	Tab8	WRITE