Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 !
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |