Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Dear All,
I am not sure this is feasible this way
I wish to find all the match between two columns by comparing each line of "Customer" to the entire column "RelatatedCust":
if any non blanks value from column "RelatedCust" is found in column "Customer" then return 1 in new column "Related Articles"
What I am triing to achieve overall is to find all related "Service":
By selcting one service (ex: "Ananas") you could see all the associated services from all the customer taking that specific service "Ananas"
If I can answer the above issue, I can then put a fitler in the new column "Related Articles"
I am happy if you have another way,
Thanks a lot for your help
NAD
Link to the file: https://www.dropbox.com/s/u0n8heaxvgltz32/Articles%20Analysis%20-%20shared.pbix?dl=0
Solved! Go to Solution.
pls try this
Related Articles =
VAR _t1 = MAX('SelectService'[Service])
VAR _tbl = SELECTCOLUMNS(FILTER(ALL(Data),'Data'[Service]=_t1),"dd",[Customer])
RETURN IF(INT(
MAX('Data'[Customer]) in _tbl) ,MAX('Data'[Customer]))
honestly, I didn't understand you.
My measure works without yours and it will show all the match. why obyadit her with your measure, I do not understand
pls try this for multi select from the slicer
Related Articles =
VAR _t1 = VALUES('SelectService'[Service])
VAR _tbl = SELECTCOLUMNS(FILTER(ALL(Data),'Data'[Service] in _t1),"dd",[Customer])
RETURN IF(INT(
MAX('Data'[Customer]) in _tbl) ,MAX('Data'[Customer]))
pls try this
Related Articles =
VAR _t1 = MAX('SelectService'[Service])
VAR _tbl = SELECTCOLUMNS(FILTER(ALL(Data),'Data'[Service]=_t1),"dd",[Customer])
RETURN IF(INT(
MAX('Data'[Customer]) in _tbl) ,MAX('Data'[Customer]))
Great it works !! thanks a lot @Ahmedx
Would you see a way to merge my 2 meaures into one, the idea is to have a table that looks like this : where I could rank the "related articles" (ideally the columns of the mesure should not be visible
Thank you very much
Here are the 2 measures:
honestly, I didn't understand you.
My measure works without yours and it will show all the match. why obyadit her with your measure, I do not understand
Last questions and thank you for your time
- Would you see a way to have multi select from the slicer
- Could the measure works with filter on the page : exemple date: Year (when I tested it, seems that the results where a not right)
pls try this for multi select from the slicer
Related Articles =
VAR _t1 = VALUES('SelectService'[Service])
VAR _tbl = SELECTCOLUMNS(FILTER(ALL(Data),'Data'[Service] in _t1),"dd",[Customer])
RETURN IF(INT(
MAX('Data'[Customer]) in _tbl) ,MAX('Data'[Customer]))
All good, thank you very much !
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
99 | |
38 | |
37 |
User | Count |
---|---|
158 | |
125 | |
76 | |
74 | |
63 |