Forum Discussion
Helper IIIFiltering many-many relationships not working
Helper IIII 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.
Community ChampionOk, no problem afaro
If the data type is the same for both tables, this should work.
Also check if you turn off interaction or not
If 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.