Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filtering OUT names from a separate table

I have a master list that has all users listed by their ID.  Then i have specific groups that we ran tests against and collected information on for those groups.  I know i can use the filter, and fil...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yep, not working.  I can get the measure created, i disconnected the group list from the master table.  I think the complexity of another table where the activity is held may be causing issues.  When i add the measure to the filter on the card i have for "passed" % calculation.  I had to add a slicer for date - month/year to pull out data on specific time frame.

Reality - i have the following tables:

Activity table and when the activity occurred

Master table - provides link to user detailed information (most measures are created under this table

Then each table that now has a different group list to find understand that groups data.

 

I would need to scrub my pbix file, as it contains sensitive info.  All tables are have the same userID as the main key for linking.

 

I also was able to create a slicer with the group data that is no longer linked, but it doesn't impact the % passed data, and when adding the select measure to the visual filter, it doesn't allow me to update to state 1. 

danielkrol's avatar
danielkrol
Helper II
6 years ago

It's hard for me to completely oversee, since the model is not known.

 

The disadvantage of filtering out this way is that it is all done by coding DAX, so you also need to change your other measures.

 

There are also techniques that use parameters to determine which rows to load into the datamodel. A change in a parameter causes the data to be loaded again, but then you can constrain the data by the value of the parameter. Never used it, and I don't know if it can help out, since loading data can take up quite an amount of time.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    So i'm thinking, is there a way to build a new table from my master table but not include the group?

    • danielkrol's avatar
      danielkrol
      Helper II
      6 years ago

      In Power Query you can create a copie of your table and the remove the column without the group. But I'm not sure if that is what you need though.