Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Circular DEPENDENCY Relationship

Hi Good People PBI, I needed to create a new table based on calculation from Table 1 My table looked like this Table 1: IDNO Store_Number Slow  AA1 S1 y AA1 S2 n AA1 S3 y AA...
Need Help
Tips and Tricks
Tutorial Requests
MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

Don't know what is the calculation you are trying to achieve but if you use this code as variable in a measure maybe you can calculate other values.

 

Has you can see below using this measure:

Measure =
VAR temp_table =
    GENERATE (
        'Table';
        SELECTCOLUMNS (
            CALCULATETABLE (
                DISTINCT ( 'Table'[Store_Number] );
                'Table'[Index] < EARLIER ( 'Table'[Index] );
                'Table'[Slow ] = "y";
                ALLEXCEPT ( 'Table'; 'Table'[IDNO] )
            );
            "Affected by"; 'Table'[Store_Number]
        )
    )
RETURN
    COUNTX ( temp_table; 'Table'[Slow ] )

I'm abble to count the Y and no of the second table altough the initial code only has  4 y and 2 no: