Forum Discussion
DAX Help - Criteria from multiple tables
Hey All, I have a situation where I need to create a measure that takes into account data from multiple tables. The first table is a membership table. There is a row for each person and the m...
Hi all,
Thanks for all the help. After digging into this further I found that the issue is likely due to the relationship passing through an intermediate table which was confusing the DAX. I used SQL to bring the data over to one table and the calculation is no working properly.
James
Calculate filter should work.
Could you post a snip of data (fake if you need to) and the measure you tried?