Forum Discussion
Filter columns not equal, setup DAX
Hi all, I have a filter but I need "direction" on it, can you help me? In the last line of the DAX below I need to find the values that are not equal, but I need to know which moves are going...
I have previously used this filter for one of the directions and flipped it for the other direction for the measure of exits but now I need something dynamic
// NOT( CONTAINSSTRING( 'Mobility All'[COMING FROM Organizational unit], "TCS"))&&
// CONTAINSSTRING( 'Mobility All'[TO Organizational unit], "TCS")
The result is something like this: