Wrong filtering in measure

[chulpanvl]

Hello everyone!

I have a fact data with lower level of income and expense items given by the column "pokazatel" and monthly budget/actual values.

I also have several dimension tables that contain upper levels of income and expense items.
The hierarchy is the following:
Показатели (upper) > statia_BI (middle) > statia_OIK (lower level)

So my model data looks like this

I want to create a measure which returns a sum of actual values filtered by a given upper level item "Оплата прочим собственникам"

test = CALCULATE(sum('bdr'[fact_mn]), 'Справочник_группы статей'[Показатели] = "Оплата прочим собственникам")

And I want to see how all levels of items contribute to this measure.
But smth odd happens when I put all of these in a table. The upper level is not shown correctly, column Показатели contains other items too.

Could you pls give me any hints what I'm doing wrong? than you!

[v-yalanwu-msft · Accepted solution]

Hi, @chulpanvl ;

You could try it.

test = CALCULATE(sum('bdr'[fact_mn]), FILTER('Справочник_перевертыш - > группы',[group_statia_BI] = "Оплата прочим собственникам"))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chulpanvl]

@lbendlin Hi! Thank you for your answers. I managed to replicate the issure even with 1 to many and single directional relationship. I updated the sample board, it's under the same link. 

[lbendlin]

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[chulpanvl]

@lbendlin I've prepared a dashboard to play around with it. You can find it here pbix.

The problem is that I get a row duplicated in a table visual.

[lbendlin]

Thank you for providing the sample data. That helps a lot with proposing a potential solution.

Your data model needs some attention.  Identify which tables are facts, which are dimensions, and which can be combined.  Ideally ou want to end up with single direction 1:M relationships, not with 1:1, and not with bidirectionals.