Forum Discussion

akay23's avatar
akay23
Icon for Helper I rankHelper I
3 years ago

Crossfilter can only use the two columns references participating in relationship error

Hi all, I have table that has 700k rows like, Oag1: And I duplicate that. Oag 2: And I want to crossjoin these tables with conditions as a calculated table. I used this formula ...
Need Help
akay23's avatar
akay23
Icon for Helper I rankHelper I
3 years ago

Hi all,
I created a Key for each table.

and I use thi formula;

 

    FILTER(
    FILTER(
        FILTER(
            CALCULATETABLE(CROSSJOIN('oag 1','oag 2'),
                USERELATIONSHIP('oag 1'[Key 1],'oag 2'[Key 2])),
                
                'oag 1'[Key 1] = 'oag 2'[Key 2]),
                
                'oag 2'[zmn2] > 'oag 1'[zmn1]),
                'oag 2'[zmn2] - 'oag 1'[zmn1] < 2)

 

This is so faster right now. But it is not enough yet.
I want to put filters into calculatetable function.

I keep researching 🙂