Forum Discussion

FlavioRB's avatar
FlavioRB
Frequent Visitor
8 years ago

All clients in the same segment

Guys,

 

Seems quite simple problem to solve, but I’m struggling to design a set of measures that compare a filtered client with other in the same industry. Here’s the model:

 

 

In a report I want to be able to, once I filtered [Dim Client]Client, show some measures build from Fact Sales of competitors in the same industries of the filtered Client.

 

I’m already using two-way filter (so I can easily identify a filtered client’s industries). In the report I also disconnected the visuals from the client slicer, but I’m having a hard time to design a CALCULATE + FILTERS that would filter in Fact Sales. Detail: a client has multiple categories and eventually is present in multiple industries.

 

Does anyone has a clue?

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    8 years ago

    Hi FlavioRB,

     

    Could you please share your sample data and post expected result based on sample data? By the way, your first picture had not been posted successfully. kindly post it again.

     

    Regards,

    Frank

     

    • FlavioRB's avatar
      FlavioRB
      Frequent Visitor
      8 years ago

      Hey v-frfei-msft thanks for the quick response.

       

      Here's a model showing what I'm trying to do: Model

       

      For some reason, I tried a couple table filtering methods and many-to-many approaches but failed to build a measure showing the competitors metrics.

       

      Best,

      FlavioRB