Forum Discussion
Look for a value filtering by month
Super Userhi Juan_91
everything is from Table2, so it has nothing to do or no impact to the relationship with anything.
Hi! Ah you do it only with table 2. I would need also table 1 because i would like to know the names that don't appear. If i do an active relationship i can do it, because the dynamic table can show me all the names of table if i want. But in my example i have an inactive relationship 😞 and i don't want to change it.
- FreemanZ
hi Juan_91
if you need names column from table1, try like:
measure 1= CALCULATE( COUNTROWS(Table2), USERELATIONSHIP(Table1[Names],Table2[Names]) ) +0the point is to add +0 in the end.
it worked like:
Oh yes that works very well in that case! But i had one more problem 😬. Sory😅! I think we are very close.
My table 1 have also dates (like below); and both table 1 and table 2 have an active relationship with a calendar table (that i want to use it for the filter). So, when i do your measure and then filter by date with the calendar table it takes me the dates of table 1 (i don't need that dates)
If i want i can take the dates of table 2 to filter and works very well! But i would like to take the date of the calendar date.I promise the next time i will be more clearer.
Table 1 Date Names Jan John Jan Michael Jan Jacob Feb Oliver Feb Jake Feb Tom