Issue with filter

[hisackman]

Having an issue with my filters. Refreshed my data and for some reason, one month (Oct.) is not attaching to the filter type. Meaning when I filter for one or the other, or even both (i.e. not select all), no amount appears. The data sets are not linked other than by State. Why would this be happening? Particularly to a specific month?

[Anonymous]

Hi ALL,
Firstly @uzuntasgokberk  thank you for your solution!
And @hisackman ,It's been a while since I've heard back from you and I wanted to follow up. Have you solved your problem yet, I would like to know if you are experiencing this problem in desktop or in service side.
Because from what we've heard so far, using matrices and filters on the service side can cause the values to appear out of whack!
If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!

[uzuntasgokberk]

Hello @hisackman,

Most of the time, the problem that comes up is that it doesn't create the relationship correctly. İt is about the issue of filter context and your measure. İf you have used a measure that don't have CALCULATE dax. You can use CALCULATE function. Because CALCULATE have a context transition status.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[hisackman]

There is no measure being used here. It is simply two data sources that have relationships to the calendar/date.

[uzuntasgokberk]

Hello @hisackman ,

Could you give an example demo pbı file.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |