I encounter a problem wanting to filter from field date hierarchy month

[Syndicate_Admin]

Good morning, how are you?

Let's see if someone could help me, I'm having a problem when filtering the MES hierarchy by a date field.

if I do not apply the date filter everything appears correct, but if I apply the filter to the month not only do the REQ that do not correspond to that MES continue to appear but the totals are set to 0 (attached the screen print)

I tried several different things, but so far I can't get records that stay at 0 to be hidden.

What I understand is that when applying the filter the calculation is not made on the measure that goes in that box.

From already thank you very much,

Best regards.

[lbendlin]

Usually that is caused by a miswired data model.

Please provide only sample data that is relevant to your issue, and provide it in usable format (not as screen shots). Indicate your expected outcome.

[Syndicate_Admin]

Good day, how is it going? As it would be that poorly wired data, I am new to Power BI and I do not understand well.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

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

[Syndicate_Admin]

Thank you very much for the answer!
Let's see if I can do better.

In the images I show what happens to me and now I explain what I need, what is happening to me is that when selecting a month that is part of the Hierarchy of the field "Compromised installation date" in the matrix puts the values in 0 of the REQ (records) that do not correspond to that month, but it does not hide them as I would need you to do, when I choose February I need only the records that have in the field "date of compromised installation" a value within that month for example: 10/02/2023 but if there is a value dated in a different month I need it not to appear.
I don't understand why it keeps showing it at 0.

Attached. PBIX so that if someone can see it can do the test, nose if it is a problem in the parameterization of the database.

Test.pbix

[lbendlin]

Thank you for providing the sample PBIX.  It may be tempting to provide information that is not relevant for the question, but it doesn't help us help you.

You will want to focus on learning about data models, especially star and snowflake schemas. For each of your tables identify if they are more "dimension" or more "fact"  and wire them accordingly. Avoid *:* and bidirectional connections where possible.

You also will want to include a calendar table in your data model.