Forum Discussion

Viswa11's avatar
Viswa11
Frequent Visitor
2 years ago

Need Help in finding Dependent table data

Hi All,   I have below columns in my dataset. table_name - T1,T2,T3.., tenant_name - A, B, C.. Unique values, Operation - Read, Write, Other Wave - Wave1, Wave2, Wave3, Wave4 I want to find ...
Need Help
Tips and Tricks
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
2 years ago

Hello Viswa11,

 

Can you please try the following:

DependentCount = 
SUMX(
    FILTER(
        'YourTable', 
        'YourTable'[DependencyStatus] = "Dependent"
    ), 
    1
)
Viswa11's avatar
Viswa11
Frequent Visitor
2 years ago

Hi Sahir_Maharaj ,
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 (
    'Table'[Operation] = "WRITE",
    IF (
        CALCULATE (
            COUNTROWS ('Table'),
            FILTER (
                'Table',
                'Table'[Operation]  = "READ"
                && 'Table'[TENANT_NAME] <> EARLIER ('Table'[TENANT_NAME])
                && 'Table'[TABLE_NAME] = EARLIER ('Table'[TABLE_NAME])


            )
        ) > 0,
        "Dependent",
        "Not Dependent"
    ),
    "Not Applicable"
)