Trying to show counts by categories over time, but values are duplicated for each category and month

[waterdatadude]

Hey Good People!

I'm still pretty new to Power BI, so humble apologies if this is (as I think it may be) remedial, but I'm crafting a pretty simple visualization where I'm trying to show the count of work orders for each type of failure code, shown by month for the last 18 months. However, it's showing the same value for each failure code category, for every month, which is not correct. I've retraced my steps, and I have a similar visualization that I created the same way that works well, but when I switch the category to failure code, the data just flattens and this is what I'm getting. (P.S. please pardon the symbology, this is draft as I'm just trying to get the work order count to show unique values per failure code type.)

Thanks in advance for any insight!

[amitchandak · Accepted solution]

@waterdatadude , it means join is missing between the tables use or it is inactive