Forum Discussion

Hussard's avatar
Hussard
Frequent Visitor
8 years ago
Solved

Filter table

Hello,   I have a big log connection table with these fields : ID, AppName, Version, UserLogin and ConnectionDate   I created a new table with DAX (Aim : have only one row by appName, Version and...
Need Help
  • popov's avatar
    popov
    8 years ago

    Hello,

    You need to create relationship between initional table and calculated table. You should to create calculated column in initional table, something like this:

    LogGroupId = LogTable[AppName]&LogTable[Version]&LogTable[UserLogin]

    i.e. combination of key fields. Next step - add this column in SUMMARIZE construction, next - create relationship between tables using column LogGroupId. You need to set crossfilter direction option to Both

popov's avatar
popov
Resolver III
8 years ago

Hello,

You need to create relationship between initional table and calculated table. You should to create calculated column in initional table, something like this:

LogGroupId = LogTable[AppName]&LogTable[Version]&LogTable[UserLogin]

i.e. combination of key fields. Next step - add this column in SUMMARIZE construction, next - create relationship between tables using column LogGroupId. You need to set crossfilter direction option to Both

Hussard's avatar
Hussard
Frequent Visitor
8 years ago

Hi,

 

Thanks popov and magsod for your replies.

 

I used popov' solution and it works very well 

 

Thanks