All clients in the same segment

[FlavioRB]

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?

[v-frfei-msft]

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]

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