Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 login)
Table = SUMMARIZE(LogTable;LogTable[AppName];LogTable[Version];LogTable[UserLogin])
But now I would add a slicer and select some interval of dates (source the parent table) and this interval "filter" the new table.
How can I amend my formula to take this filter ?
Thanks !
Solved! Go to Solution.
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
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
Hi,
Thanks popov and magsod for your replies.
I used popov' solution and it works very well
Thanks
The calculated table (the new one that you created with DAX) does note update or respond to selections in a report slicer. In that sense the calculated tables are "static" and will only be recalculated during a data refresh.
For your scenario it should work fine without the DAX table. Simply add a table visual to your report where you add the columns AppName, Version and UserLogin.
The table visual will only show one row for each distinct combinaton of your values so if you avoid the ID or the ConnectionDate in the table visual I think you end up with a working solution for you?
Br,
Magnus
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |