Forum Discussion
PowerBI Model not Filtering as Expected
ninashand , As the opportunity name comes from a table at the same level as event details, you might not see the correct result in that case. Prefer a drill-through a report or tooltip report that do not use event details measures
If it's the same value that using on [Segment Target] and [Event Detail], you might just pick those field from [Segment Target] instead.
If Hierarchy Filter is trying to build hierarchy line under [Event] > [Segement Target] >[Opportunity] only.
It's logical to have subset of opportunity value follow the hierarchy.
However, If Hierarchy Filter is trying to build hierarchy line under [Event] > [Segement Target] > [Event Detail] >[Opportunity]. (as you told the visual to do, by pulling [Event Detail] fields into it).
There the linkage of [Event Detail] > [Opportunity] just will happen as "open join", ie, it join every [Event Detail] to every [Opportunity].
This explained your unwanted result.
If it's the same value that using on [Segment Target] and [Event Detail], you might just pick those field from [Segment Target] instead.
If Hierarchy Filter is trying to build hierarchy line under [Event] > [Segement Target] >[Opportunity] only.
It's logical to have subset of opportunity value follow the hierarchy.
However, If Hierarchy Filter is trying to build hierarchy line under [Event] > [Segement Target] > [Event Detail] >[Opportunity]. (as you told the visual to do, by pulling [Event Detail] fields into it).
There the linkage of [Event Detail] > [Opportunity] just will happen as "open join", ie, it join every [Event Detail] to every [Opportunity].
This explained your unwanted result.