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.

POWER_MI's avatar
POWER_MI
Post Patron
5 years ago

Hi all, 

v-yingjl I have updated the project with details explained on last message. 

This is the project with other application so you will see that it's not working

 

Project; this link 

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

Hi POWER_MI ,

Based on your sample file, there are three tables and two slicers in the report, what is your expected output, could you please consider sharing more details about it?

If add relationships to tables, what is the related field, [column] and [level]?

 

Best Regards,
Community Support Team _ Yingjie Li

  • POWER_MI's avatar
    POWER_MI
    Post Patron
    5 years ago

    Hi All,

     

    Hello v-yingjl  

    The Table COLOR Field is the Global Table.
    Table Is used to define Color of Rows on dashboard based on criteria level AND color field[R1, R2....]
    SELECTEDVALUE( 'Table'[Level] ) = "A1", CALCULATE([Measure1], COLOR_FIELD_TO_ADD[Coulumn] IN { "R1", "R2", "R31" }),

    So This option is Just to Make color on Table results.

    And Now it's added to the Update of selection of control mesure on this same project so means :
    For color we can keep it and we just add filter to select Soon project based on Mother project ( Table 'Project).
    Hope that it's clear.
    When adding control mesure and filter as you explaned No any results ?

    Thanks in advance

    Project; this link 

    • 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