Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community,
I would like to be able to show customers a list of engineers where the Engineer specified the product that they care about, but did not specify the company brand. I believe we could do this by creating a new measure, or possibly a new column.
Example:
If project 123456 is a match for the product search (ID # 3) AND is NOT a match for the brand search (ID # 😎 then I want to show the Engineer for that project. If both IDs are a match, I do not want to show the architect for that project.
So, a visual way of explaining this is, if:
Project ID 3 ID 8 Show Engineer?
123456 Match Match No
123456 Match No Match Yes
123456 No Match Match No
123456 No Match No Match No
Please Help.
Thanks,
Paruchuri
Solved! Go to Solution.
@Anonymous,
You may refer to the measure below.
Measure = IF ( CONTAINS ( Table1, Table1[Id], 3 ) && NOT ( CONTAINS ( Table1, Table1[Id], 8 ) ), 1 )
Hi @Anonymous,
Please try this formula in a column and check image below:
Test = if(AND(Data[Product]="Match",Data[Brand]="No Match"),"No","Yes")
Let us know if it does not work...
Ninter.
Hi Interkoubess
Thanks for your reply. This is not what i am looking for.
I have explained the same in the example. If the project number is found in both id(3 and 😎 then i don't want to show the record. If the project number is found in only one of the search then i want show the record.
Project No Id
123456 3
123456 8
If the data is like above i don't want to show.
Project No Id
123456 3
If the data is like above i want to show.
Thanks,
Paruchuri
@Anonymous,
You may refer to the measure below.
Measure = IF ( CONTAINS ( Table1, Table1[Id], 3 ) && NOT ( CONTAINS ( Table1, Table1[Id], 8 ) ), 1 )
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |