Forum Discussion
Dealing with Multi Value fields (ie Multi-select list or picklist)
Hi Lin
Thanks for going to the trouble to make that file and provide screenshots. I really appreciate it. I loved the way that multi-Select control worked with PBI, however its not quite what I was looking for. The Multi-select list data I have in PBI is brought into the PBI file from Salesforce live link. The users of the PBI reports are not going to be selecting any values...they want to see a report on what others have been up to when visiting schools and providing resources which they enter in Salesforce.
I am going to give a screenshot below of the data table on the left and the report output the manager wants on the right. It is identical to the output in your example however my input is different. I cannot get away with using "IF SELECTEDVALUE(" as my resource values are not distinct for each record.
Data on left is live data
Community Supporthi, smathers
After my research, for your data source is live connection, It could be achieved for now. all the values is in the one field and It needs to be split. Your requirement needs to be the data source or get data by Import.
and I have a kind of method for you to refer to.
For example:
Step1:
In the Edit Queries, select RESOURCES Provided column then duplicate this column.
Step2:
Select the duplicate column then click Transform->Split Column->By delimiter
Step3:
select basic column then right click select Unpivot other columns
get
Step4:
Close&Apply and create a measure
times = CALCULATE(COUNTA(Table1[Value]))
Result:
here is pbix, please try it.
Best Regards,
Lin
BokazoitContinued Contributor
Hi
I am in a similar situation and that solution I thought of myself, but my problem is that I also has a value attached. So in a normal fact I will have one line pr. value, but transposing it as You do creates multiple values and then the sum will be incorrect since I would sum the value as many times as the multianswer is reproducing the line.How to do that?