Forum Discussion

Covington's avatar
Covington
Icon for Helper I rankHelper I
7 years ago
Solved

Find Differences in column

I have a set of data that I am querying out of a database that has the following fields:   Node Tag Name Address   There are multiple nodes that *may* have a Unique Address.  Mostly, the Add...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Covington 

     

    Not sure if I understood the requirement, but try this code, it will return true if there is more then one address variation per tag.

     

    Column = 
CALCULATE( 
    DISTINCTCOUNT( YourTable[Address] ), 
    ALLEXCEPT( YourTable, YourTable[Tag] ) 
) > 1

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Covington 

 

Not sure if I understood the requirement, but try this code, it will return true if there is more then one address variation per tag.

 

Column = 
CALCULATE( 
    DISTINCTCOUNT( YourTable[Address] ), 
    ALLEXCEPT( YourTable, YourTable[Tag] ) 
) > 1

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski