Power BI: Combining cells from a column where given a condition
<p>I have to perform a task in power BI (DAX) where i have a list of users and their fields of work.
I have to combine all the fields corresponding to every user and find the highest frequency combination.<br>
Below is how I was planning to do it. 
How can i generate the "Expected Result" from the "Sample" file?  </p>

<pre><code>Sample:
    ID     Value
    a      medicine
    b      automobile
    c      banking
    d      scientist
    a      banking
    a      scientist
    d      banking

Expected Result:
ID      Value Combi
a       medicine|banking|scientist
b       automobile
c       banking
d       scientist|banking
</code></pre>