Forum Discussion

POWER_MI's avatar
POWER_MI
Post Patron
5 years ago
Solved

Filter's Data between two table Help

Hi all,    I have some dobt with Power Bi to make and create this functionality.  There are two tables table 1 and table 2. Table 1 coloumn is Son Project / GROUPE PROJECT / COULUMN1 /COULUMN2 / ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi POWER_MI ,

    You can put the version column in the matrix and apply this measure to replace the previous:

    A =
SWITCH (
    SELECTEDVALUE ( Project[Project] ),
    "mother1",
        IF (
            CALCULATE (
                COUNTROWS (
                    FILTER (
                        'Project',
                        CONTAINSSTRING (
                            SELECTEDVALUE ( COLOR_FIELD_TO_ADD[Soon_Projet] ),
                            'Project'[Project]
                        )
                    )
                ),
                FILTER ( 'COLOR_FIELD_TO_ADD', 'COLOR_FIELD_TO_ADD'[Version] = "Version A" )
            ) > 0,
            1
        ),
    "mother2",
        IF (
            CALCULATE (
                COUNTROWS (
                    FILTER (
                        'Project',
                        CONTAINSSTRING (
                            SELECTEDVALUE ( COLOR_FIELD_TO_ADD[Soon_Projet] ),
                            'Project'[Project]
                        )
                    )
                ),
                FILTER ( 'COLOR_FIELD_TO_ADD', 'COLOR_FIELD_TO_ADD'[Version] = "Version B" )
            ) > 0,
            1
        ),
    "mother3",
        IF (
            CALCULATE (
                COUNTROWS (
                    FILTER (
                        'Project',
                        CONTAINSSTRING (
                            SELECTEDVALUE ( COLOR_FIELD_TO_ADD[Soon_Projet] ),
                            'Project'[Project]
                        )
                    )
                ),
                FILTER ( 'COLOR_FIELD_TO_ADD', 'COLOR_FIELD_TO_ADD'[Version] = "Version C" )
            ) > 0,
            1
        )
)

    Attached the file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi POWER_MI ,

The control measure calulated based on comparing two columns, since you there is no [Son Project] field in the matrix, you will see no data in the visual when you enable this measure.

You can add the field into the matrix, enable the control measure and drill down the matrix:

Attached the file in the below, hopes to help you.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

POWER_MI's avatar
POWER_MI
Post Patron
5 years ago

Hi all, 

v-yingjl  thanks a lot it's ok about color. 

there are another update. It's same like select project_soon_mother1 based on mother_1 project

 

 

If MOTHER PROJECT = _mother1  on table results or on table 1 will take juste 

All rows with condition Son Project=Proj_soon_mother1 and  Version = Version_A  ( version is column in Color_Field_Table)

 

If MOTHER PROJECT = _mother2  on table results or on table 1 will take juste 

All rows Son Project=....__mother2 and Version = Version_B

 

If MOTHER PROJECT = _mother3  on table results or on table 1 will take juste 

All rows Son Project=....__mother3 and Version = Version_C

Link is here 

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi POWER_MI ,

    You can put the version column in the matrix and apply this measure to replace the previous:

    A =
SWITCH (
    SELECTEDVALUE ( Project[Project] ),
    "mother1",
        IF (
            CALCULATE (
                COUNTROWS (
                    FILTER (
                        'Project',
                        CONTAINSSTRING (
                            SELECTEDVALUE ( COLOR_FIELD_TO_ADD[Soon_Projet] ),
                            'Project'[Project]
                        )
                    )
                ),
                FILTER ( 'COLOR_FIELD_TO_ADD', 'COLOR_FIELD_TO_ADD'[Version] = "Version A" )
            ) > 0,
            1
        ),
    "mother2",
        IF (
            CALCULATE (
                COUNTROWS (
                    FILTER (
                        'Project',
                        CONTAINSSTRING (
                            SELECTEDVALUE ( COLOR_FIELD_TO_ADD[Soon_Projet] ),
                            'Project'[Project]
                        )
                    )
                ),
                FILTER ( 'COLOR_FIELD_TO_ADD', 'COLOR_FIELD_TO_ADD'[Version] = "Version B" )
            ) > 0,
            1
        ),
    "mother3",
        IF (
            CALCULATE (
                COUNTROWS (
                    FILTER (
                        'Project',
                        CONTAINSSTRING (
                            SELECTEDVALUE ( COLOR_FIELD_TO_ADD[Soon_Projet] ),
                            'Project'[Project]
                        )
                    )
                ),
                FILTER ( 'COLOR_FIELD_TO_ADD', 'COLOR_FIELD_TO_ADD'[Version] = "Version C" )
            ) > 0,
            1
        )
)

    Attached the file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.