Forum Discussion
Helper IIIFiltering many-many relationships not working
Community ChampionHi afaro
Please check the Year column datatype in both table
when I use the year from the Automation Forecast table as slicer
Is the Automation Forecast table 3rd table in your data model, please check the filter
afaroI made a typing error.
The Sales and Automation Forecast table are the same table. Mistakenly used different names for the same table. I don't see an option to edit my post, I would have edited it now if not for that.
- PijushRoy
Ok, no problem afaro
If the data type is the same for both tables, this should work.
Also check if you turn off interaction or notIf not solved,
Please create a pbix that contains sample data but still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or dropbox and share the link in this thread. If you are using a spreadsheet to create/import the sample data instead of the manual import method, share the spreadsheet as well.
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin- afaro
Changing the datatype didn't work but I added an intermediate year table with year values between the two tables and then it worked.