Forum Discussion

robertsbm's avatar
robertsbm
Frequent Visitor
8 years ago

Displaying the difference between two visuals into a third visual

Hi all!   I'm trying this again and will provide better detail. I simplified my data model and will expain with screenshots. The purpose of the report is to query several different databases and li...
Need Help
  • robertsbm's avatar
    robertsbm
    Frequent Visitor
    8 years ago

    Thanks for the reply. I wrote up something like this but it's not working correctly. Tables "SOURCE DATA" and "TARGET DATA" contain the same data, the only difference is the applied Environment filter. How can I ensure that both filters for source and target environemnts are applied? Is this the correct approach?

     

     Column = IF(NOT('SOURCE DATA'[Application Name] IN VALUES('TARGET DATA'[Application Name]))
                         && NOT('SOURCE DATA'[Application Version] IN VALUES('TARGET DATA'[Application Version]))
                         && NOT('SOURCE DATA'[Ruleset Name] IN VALUES('TARGET DATA'[Ruleset Name]))
                         && NOT('SOURCE DATA'[Ruleset Version] IN VALUES('TARGET DATA'[Ruleset Version])),
                        'SOURCE DATA'[Ruleset Version],"Exists")