Forum Discussion
USERELATIONSHIP don´t work
Hello everyone,
I need some help please, I have two related tables using USERELATIONSHIP in directquery that is not working
I created a measure to bring the total but it is repeating for all codes (CAK AJUST)
I realized that there are blank spaces in the code and I used the TRIM but I can't use it in the power query because directquery doesn't allow it and I've already tested it, so I could only think using measures.
tks
Spotto , You can add filter on the column having blank or blank space
after userealtionship
not(isblank(Table[Column])) && TRIM(Table[Column]) <> ""
refer the terminated https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
1 Reply
Spotto , You can add filter on the column having blank or blank space
after userealtionship
not(isblank(Table[Column])) && TRIM(Table[Column]) <> ""
refer the terminated https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970