Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |