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.
I have a joined table of opportunities and products grouped by product line, e.g.
Opp | Product Line
A | X
B | Y
C | X
C | Y
D | Z
I'm interested in being able to filter on the Opportunities like C, where they contain two specific product lines (X and Y). All assistance appreciated.
Solved! Go to Solution.
Hi @Anonymous
Try this Column
OppContainsXandY = VAR Mytable = FILTER ( TableName, TableName[Opp] = EARLIER ( TableName[Opp] ) ) RETURN IF ( CONTAINS ( mytable, TableName[Product Line], "X" ) && CONTAINS ( mytable, TableName[Product Line], "Y" ), "Yes", "No" )
@Anonymous
If you want to filter your table, you can simply use a slicer. Please refer:
If above sample doesn't satisfy your requirement, please kindly elaborate your requirement with detailed description and your desired result.
Thanks,
Xi Jin.
I'm trying to find opportunies like C... i.e. opportunities that contain both product line X and product line Y. The Opportunity column is in reality an Opp ID not a category of opportunity. Perhaps it would be clearer to say that producing a category to filter on is what i'm trying to do.
Opp | Product Line | OppContainsXandY
A | X | No
B | Y | No
C | X | Yes
C | Y | Yes
D | Z | No
E | Y | Yes
E | X | Yes
F | X | No
F | Z | No
G | X | Yes
G | Y | Yes
G | Z | Yes
What is the DAX to create the column OppContainsXandY?
Hi @Anonymous
Try this Column
OppContainsXandY = VAR Mytable = FILTER ( TableName, TableName[Opp] = EARLIER ( TableName[Opp] ) ) RETURN IF ( CONTAINS ( mytable, TableName[Product Line], "X" ) && CONTAINS ( mytable, TableName[Product Line], "Y" ), "Yes", "No" )
@Anonymous
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |