Forum Discussion

Sasha's avatar
Sasha
Icon for Helper III rankHelper III
7 years ago
Solved

Comparing field to itself

I have the following data about ownership of barbers in three barber shops I'm interested presenting a matrix on PBI where the rows are barbers that are owners in at least one barber shop and th...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Sasha ,

     

    Drag [Barber] from Table2 to Rows and add measure below.

    Table2 =
FILTER ( Table1, Table1[Status] = "Owner" )

    Measure =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( Table2[Barber] ) = SELECTEDVALUE ( Table1[Barber] ), "Same Person",
    NOT (
        ISEMPTY (
            FILTER (
                Table1,
                Table1[BarberShop] IN VALUES ( Table2[BarberShop] )
                    && Table1[Status] = "Owner"
            )
        )
    ), "Owners",
    NOT (
        ISEMPTY (
            FILTER ( Table1, Table1[BarberShop] IN VALUES ( Table2[BarberShop] ) )
        )
    ), "Owner-Tenant"
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Sasha ,

 

Drag [Barber] from Table2 to Rows and add measure below.

Table2 =
FILTER ( Table1, Table1[Status] = "Owner" )

Measure =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( Table2[Barber] ) = SELECTEDVALUE ( Table1[Barber] ), "Same Person",
    NOT (
        ISEMPTY (
            FILTER (
                Table1,
                Table1[BarberShop] IN VALUES ( Table2[BarberShop] )
                    && Table1[Status] = "Owner"
            )
        )
    ), "Owners",
    NOT (
        ISEMPTY (
            FILTER ( Table1, Table1[BarberShop] IN VALUES ( Table2[BarberShop] ) )
        )
    ), "Owner-Tenant"
)
Sasha's avatar
Sasha
Icon for Helper III rankHelper III
7 years ago

Awesome!

Thanks!