Forum Discussion
Label non match and match problem
Super UserAnonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
My goal is to create a new field Segment Group which have these entries:
| Segment |
| No Match in Table CustInfo |
| A |
| B |
| C |
| D |
| with Match in table CustInfo but no info on segment |
The problem I am encountering is in my dashnoard there is a blank and unknown entry for the Segment field, higlighted below:
I want to combine the highlighted Unknown and blank fields into the new column Segment Group. However, the first one, blank Segment, is actually IDs that dont have a match in CustInfo table whereas the Unknown has a match BUT no value for Segment on the CustInfo table. CustInfo and Historytbl are connected by ID in the model.
If I dont put the revenue field from Historytbl, what happens is:
But if I add it, a blank entry is added in the table:
To put it another way:
I want to create a new field, Segment Group that first checks if ID will have a match in CustInfo so the output will be
Match
No Match.
However, I want to expand on the Match with the corresponding Segment values. So the result will be
I want column C as my column.