Help with this problem

[Oceans88]

Hi All,

Im having dificukties with this one: 

- Table A = Has unique number of GUIDs im tracking

- Table B =

• Has Sales numbers in for thousands of GUIDs 
• Has a 3 columns User GUID, End User GUID, Sales KUSD

What i want to achieve is how to track only selected GUIDs from Table A in Table B for both User & EndUser. 

What i was thinkning is:

Creating a calculated column or measure that does the following:

If ( TableA[GUID] = TableB[User GUID] and_or TableB[End User GUID]; Display found GUID;  Display nothing)

The point is to display a new custom column with GUID found in above operation. 

Any ideas how i can code somthing like this in Query editor? 

Thanks for any help

[v-lionel-msft · Accepted solution]

Hi @Oceans88 ,

"What i want to achieve is how to track only selected GUIDs from Table A in Table B for both User & EndUser. "

"The point is to display a new custom column with GUID found in above operation. "

Maybe you can try this measure:

Measure = 
IF(
    SELECTEDVALUE('Table A'[ GUIDs ]) = MAX('Table B'[User GUID]) || SELECTEDVALUE('Table A'[ GUIDs ]) = MAX('Table B'[ End User GUID]),
    MAX('Table A'[ GUIDs ]),
    BLANK()
)

Best regards,
Lionel Chen

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

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490