Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I need to tag segment from another table.
Segment is from lookup table CustInfo.
Sales is from fact table HistoryTbl.
I want it to tag:
Unknown Segment, if CIDN is in CustInfo but no segment value
Unmatched CIDN, if CIDN is not in CustInfo totally.
As you can see, I want to tag the top as "Unmatched CIDN" and retain the other matching segment values. The last entry UNKNOWN has match in CustInfo BUT no value for SEGMENT. I dont want it to tag only match or unmatch. If there is a match then it should display the segment values accordingly.
@Anonymous ,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.
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |