assign value if there are field matches in multiple tables

[telesforo1969]

I need a measure that shows me the following result: if the value in table 2, table 3, table 4 and table 5 are equal, then it should show me the value in table 6 (Weights).

[v-sshirivolu · Accepted solution]

Hi @telesforo1969 ,

Thanks for reaching out to the Microsoft fabric community forum.

Try these Steps - 

Set up the following relationships in Model View:

Table2[ProductName] → Table1[ProductName]

Table3[ProductName] → Table1[ProductName]

Table4[ProductName] → Table1[ProductName]

Table5[ProductName] → Table1[ProductName]

Table6[ProductName] → Table1[ProductName]

Each should be a many-to-one relationship, directed towards Table1.

In Table1 use New Column -

UM_Result =
VAR Group2 = RELATED('Table2'[Group])
VAR Group3 = RELATED('Table3'[Group])
VAR Group4 = RELATED('Table4'[Group])
VAR Group5 = RELATED('Table5'[Group])
RETURN
    IF (
        Group2 = Group3 &&
        Group3 = Group4 &&
        Group4 = Group5,
        RELATED('Table6'[UM]),
        BLANK()
    )
 

Find attached document for your reference

Best Regards,
Sreeteja.

[telesforo1969]

Thank you very much. I will review the information you shared with me

[v-sshirivolu]

Hi @telesforo1969 ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

[v-sshirivolu]

Hi @telesforo1969 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

[v-sshirivolu]

hi @telesforo1969 ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

[danextian]

Hi @telesforo1969 

Is Tabla # referring to actual tables or just columns?

[gmsamborn]

HI @telesforo1969 

Would a measure like this help filtering your table?

Include = 
VAR _c2 = SUM( 'SourceTable'[Grupo2] )
VAR _Logic =
    IF(
        _c2 = SUM( 'SourceTable'[Grupo3] ),
        IF(
            _c2 = SUM( 'SourceTable'[Grupo4] ),
            IF(
                _c2 = SUM( 'SourceTable'[Grupo5] ),
                1
            )
        )
    )
RETURN
    _Logic

I hope I understood.

Let me know if you have any questions.

Added:

Is it a fixed number of groups or does it change?

[telesforo1969]

I forgot to say that the expected value, if the conditions are met, should filter a value from a catalog, in this case from the UM column of table 6. I don't see in your measure how it filters said field.

[gmsamborn]

Hi @telesforo1969 

I would like to help but I'm a little unclear about your requirements.

Can you provide the following?

1)  Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

3) Please explain how you would expect to get from step 1 to 2.

4) If possible, please show your past attempts at a solution.

 A .pbix file with sample data would be best.