Forum Discussion

cybertunnel's avatar
cybertunnel
Regular Visitor
5 years ago
Solved

Filter on Application not installed on a specific device

So I have broken down my dataset to a simple setup for argument's sake.

So I have a list of devices in 'Devices' which has the [id], [name]. I have another table 'Applications' which has the [device id], [app name]. The problem I am having is filtering on devices which DON'T have application 'Microsoft Power BI'. I can find devices which DO have it, but can't figure out how to filter on just devices which don't have the specified app.

 

Thoughts?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi cybertunnel ,

    I created a sample pbix file(see attachment), please check whether that is what you want. You can create a measure as below to get the count of devices which don't have the special character:

    Count of devices which don't have = 
VAR _searchtext = "Outlook"
VAR _tab =
    CALCULATETABLE (
        VALUES ( 'Applications'[Device ID] ),
        CONTAINSSTRING ( 'Applications'[Application], _searchtext )
    )
VAR _tab2 =
    CALCULATETABLE (
        VALUES ( 'Applications'[Device ID] ),
        NOT ( CONTAINSSTRING ( 'Applications'[Application], _searchtext ) )
    )
RETURN
    COUNTROWS ( EXCEPT ( _tab2, _tab ) )

    Best Regards

7 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    5 years ago

    Hi cybertunnel 

     

    try this filter:

    FILTER(Applications,Applications[app name]<>"Microsoft Power BI")

     

    If you share a sample of your data and result in a table format, that will help to prepare a better solution.

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

    • cybertunnel's avatar
      cybertunnel
      Regular Visitor
      5 years ago

      I was hoping for more of a filter option able to be used in a report. I was even thinking of a measure if really needed.

      The dataset I have has some sensitive information, how would I go about making a table for reference for you?

      • VahidDM's avatar
        VahidDM
        Icon for Super User rankSuper User
        5 years ago

        Hi cybertunnel 

         

        Create a sample table with some data not real data (5 or 6 rows are enough if that cover your request?

        More important, create a result table to be clear what are you looking for?

         

        Appreciate your Kudos!!

    • cybertunnel's avatar
      cybertunnel
      Regular Visitor
      5 years ago

      I actually noticed the issue with my communication, sorry for that.

      The filter your purposed, does work, but I guess my filtering is wrong, or something is flawed.

      The problem I have is the Applications table returns rows which have the name that doesn't match 'Microsoft Power BI' which might be a device with 'Microsoft Excel'. This problem allows a device which has Power BI installed, but is grabbed by the filter since there is an entry with "Microsoft Excel".

       

      Hope that helps shed the light on the issue I am having. The filter on the table relationship is in both directions on the Device's ID, just an FYI.