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.