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"
    )