Need Help

[Gabriel_Largura]

I have the table below:

and I need to generate a new table where I define the value of line 1 and the others are searched in the column 'Prox Ponto', below an example

Result

35311-512776-512777

35311-516028-512776

35311-516022-516028

35311-512597-516022

[Gabriel_Largura]

hello @v-kelly-msft , thanks for helping me!

Attached the calculation in excel and the data source, some (Prox Ponto) may be blank, it's ok.

https://drive.google.com/drive/folders/17RlVn6JdcOPzjKz2Ed0FxXMvY07cl9Cn?usp=sharing

[v-kelly-msft]

Hi @Gabriel_Largura ,

Try the function "intersect",see below:

https://docs.microsoft.com/en-us/dax/intersect-function-dax

I have created a calculated table in attachment.Check for details.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Gabriel_Largura]

hello,

it is not correct, the values ​​are different

[v-kelly-msft]

Hi  @Gabriel_Largura ,

After checking the sample data you provided,could you pls advise me why some data which can be searched in Prox Ponto is not existing in the result,such as "35311-512777-512776"?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Gabriel_Largura]

thank you @v-kelly-msft 
but still not the desired result...

I would like a result "similar" to this calculation

'tableresult' = 

line 1 = "35311-512776-512777"

line 2 = lookupvalue('table'[Prox Ponto],'table'[Indice],line 1)
line 3 = lookupvalue('table'[Prox Ponto],'table'[Indice],line 2)
line 4 = lookupvalue('table'[Prox Ponto],'table'[Indice],line 3)
.....

WHILE lookupvalue('table'[Prox Ponto],'table'[Indice],line X) <> BLANK()

[v-kelly-msft]

Hi  @Gabriel_Largura ,

Create a column as below:

Lookupvalue = LOOKUPVALUE('Table'[Prox Ponto],'Table'[Indice],'Table'[Indice],"35311-512776-512777")

 Then create a table as below:

Table 3 = 
DISTINCT(UNION(ROW("Result","35311-512776-512777"),FILTER(VALUES('Table'[Lookupvalue]),'Table'[Lookupvalue]<>BLANK())))

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft]

Hi  @Gabriel_Largura ,

First create a table as below:

Table 2 = VALUES('Table'[Prox Ponto])

Then create a measure as below:

Measure = 
IF(MAX('Table'[Indice]) in FILTERS('Table 2'[Prox Ponto]),MAX('Table'[Indice]),BLANK())

Finally create a table as you need:

Table 3 = UNION(ROW("Result","35311-512776-512777"),FILTER(VALUES('Table'[Indice]),'Table'[Indice]='Table'[Measure]))

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Pragati11]

HI @Gabriel_Largura ,

Try using Text Search custom visual in Power BI to search for a value:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview

Thanks,

Pragati