Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Newbie, forgive me. I know there are lots of examples out there but none seemed to match what I'm looking for and I'm not the best in this area.
Hoping to get help where if a slicer name is selected, a table will display all rows where the name is found in one of two columns. A link with a small file with the data & example is below. I appreciate the help.
https://drive.google.com/open?id=194jmFZgXOz-9N-EJHYr9n50rY1fYqi2c
Solved! Go to Solution.
@Anonymous
Hi use this measure:
Contained = IF ( SELECTEDVALUE ( Names[Name] ) = SELECTEDVALUE ( Data[Assigned To] ); 1; IF ( SEARCH ( SELECTEDVALUE ( Names[Name] ); SELECTEDVALUE ( Data[Back-up] ); 1; BLANK () ) = BLANK (); BLANK (); 1 ) )
ANd use a Visual Filter int the Table Visual to Contained is 1
Regards
Victor
@Anonymous
Replace ; with ,
Is just Regional Settings
Regards
@Anonymous
Hi use this measure:
Contained = IF ( SELECTEDVALUE ( Names[Name] ) = SELECTEDVALUE ( Data[Assigned To] ); 1; IF ( SEARCH ( SELECTEDVALUE ( Names[Name] ); SELECTEDVALUE ( Data[Back-up] ); 1; BLANK () ) = BLANK (); BLANK (); 1 ) )
ANd use a Visual Filter int the Table Visual to Contained is 1
Regards
Victor
Get...
The syntax for ';' is incorrect. (DAX(IF ( SELECTEDVALUE ( Names[Name] ) = SELECTEDVALUE ( Data[Assigned To] ); 1; IF ( SEARCH ( SELECTEDVALUE ( Names[Name] ); SELECTEDVALUE ( Data[Back-up] ); 1; BLANK () ) = BLANK (); BLANK (); 1 )))).
@Anonymous
Replace ; with ,
Is just Regional Settings
Regards
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |