Filtering help

[BicBiro]

Hey all, 

I'm hoping you can help - I have some data - which shows users from which groups who have used some tools, I want to understand which groups of users have used multiple tools so that I can see what tools are most often used together.

The idea is that I will be able to gain insight about which tools are used together within the groups, and use that to cross-sell additional tools to other groups with similar profiles. 

However, I want to be able to filter to show all tools which have been used alongside a specific tool. 

For example:

USER A	GROUP A	TOOL Z	20 May 2025
USER B	GROUP A	TOOL Y	20 May 2025
USER A	GROUP A	TOOL X	20 May 2025
USER C	GROUP B	TOOL Z	21 May 2025
USER A	GROUP A	TOOL Y	21 May 2025
USER D	GROUP C	TOOL Z	21 May 2025
USER D	GROUP C	TOOL Y	21 May 2025

I want to be be able to filter this for all Groups which use Tool Y and any other tools - so I'd get - Group C, Group A and a list of all the tools used in each group. 

Is this doable with advanced filters? I've tried Includes Tool Y AND * but this doesn't work...

[v-nmadadi-msft]

Hi @BicBiro ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked.

Thanks and regards

[v-nmadadi-msft]

Hi @BicBiro 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft]

Hi @BicBiro 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[DataNinja777 · Accepted solution]

Hi @BicBiro ,

You can accomplish this in DAX by creating a new Calculated Table. This approach generates a filtered version of your data based on the multi-step logic you need: first finding the groups that use a specific tool, and then showing all data for those groups.

Here is the DAX expression you would use. Simply replace 'YourTable' with the name of your actual data table and "Tool Y" with the specific tool you wish to filter by.

FilteredTable = 
VAR TargetGroups =
    CALCULATETABLE (
        VALUES ( 'YourTable'[GROUP] ),
        'YourTable'[TOOL] = "Tool Y"
    )
RETURN
    FILTER (
        'YourTable',
        'YourTable'[GROUP] IN TargetGroups
    )

This DAX code works by first creating a temporary variable named TargetGroups. This variable holds a distinct list of all groups that have at least one entry associated with "Tool Y". The RETURN statement then executes the main logic, which iterates through your original table and keeps only the rows where the group name is found within the TargetGroups list created in the first step. The result is a new table in your data model that contains the complete tool usage for only the groups that meet your criteria.

Best regards,