Forum Discussion
Need help on Creating a measure based on another table's Column
I have two tables. I want to create a measure from first table by using second table column. Created a following measure but measure value changes when I click the visuals though I used FILTER with ...
I'm struggling to understand why you need to involve Table1 in your measure.
You have [ComputerID] in Table2 that you can use to count, and you have a ONE:MANY relationship between the two tables, so all of Table1 is already included in the expanded version of Table2.
What am I missing here?
Pete
Let's assume measure is created. In first image, card created using table2 and Pie Chart created using Table1.
When i made any selection within the pie chart, measure value also changing. It should not happen in my case.. How can we avoid that