How to Flag same company from SOURCE = TS and TA ?

[admin11]

Hi All

May i know what is the faster way to flag same company from Both SOURCE ?

[V-lianl-msft]

Hi @admin11 ,

Unfortunately, the image you pasted and the sample file you provided are not accessible. Can you share again to let us know your problem.

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

[admin11]

@V-lianl-msft 

Thank you for looking into my post :

https://www.dropbox.com/s/i9aar0redqv335s/PBT_V2021_137%20how%20to%20FLAG%20same%20company%20SOURCE%...

Above link is my BPI file.

Paul

[admin11]

Hi All

Below is my PBI sample file

https://www.dropbox.com/s/67z5cv3ddi6votr/PBT_V2021_137%20how%20to%20FLAG%20same%20company%20SOURCE%...

[amitchandak]

@admin11 , Try a measure , companies with both sources

countx(filter(summarize(Table, Table[company], "_1", distinctcount(Table[sources])),[_1]=2),[company])

[admin11]

Hi All

I try not error , but display null.