Forum Discussion
One-to-one wrong filter
Grieclolu Right, I used your 2 tables originally, not a single employee in Gender that matches with Terminations. Check it yourself in the updated PBIX attached below signature. Gender3, Table3, Page3.
Grieclolu Because you have a bunch of employees that aren't terminated and thus if you count the rows in the terminations table, there are a bunch of unmatched rows, which results in the legend category of "blank". If you write those two measures, they will always work and you don't have to do anything additional to keep the data up-to-date.
Greg_Deckler I understand. Is there any other way ot automatic match the two tables? for example using other type of relation? The problem is that the data base is very big, so you should do this operation for many other cases, for example, age, type of contract, nationality etc. Moreover, i would like to add other tables, with other information, so it will became very difficult to manage everythingh with this measure.
Maybe you can advise me, as i said, another solution in how to put toghether date, or table, or relations.
Thanks a lot again,
Luca
Grieclolu Use the Filters pane and filter your legend to not include (Blank)?
It could't be a solution, since almost all the rows are red as blank.
In the screen below, i have 834 rows, that means 834 terminations. If i not include the blank, i will lose almost all the information (824). Do you need some example more? Or maybe the pbix file?Grieclolu So you don't have those terminated employees in your Gender table? Sorry, confused. PBIX would definitely help. See mine attached under my signature.