text import recognition of function

[kyrpav]

Hello, i have ta table with some metrics. On column is the thresold format header.

For one row the data look like this.

UNICHAR(128992)&":<80%"&UNICHAR(10)&UNICHAR(128993)&":80-90%"&UNICHAR(128994)&":>90%"

if i have this inside powerbi writen in a function in a measure then when i select this measure to matrix everything works and unichars apear normally.

When i import this column from db and i select the column to matrix then i see only the text. Is there anyway to make powerbi parse the function after import.?

[vanessafvg]

are you saying you want power bi to run a function that is sitting in cell? it will see it as a string, not a function if that is what you saying

[kyrpav]

Yes it sees it as string , i want to know if there is a way to transorm this later.

[vanessafvg]

wouldn't think so no, you need to put the function in the right place, not in the value of the field.

[kyrpav]

If i have a table with metric headers which mean i have a table like

metric_id	thresold_id	thresold_header
1	1	header1
1	2	header2
1	3	header3
2	1	header4
2	2	header5
2	3	header6

How can i add another column (not measure cause i want to place it in rows in matrix) that concatenates all headers per metric. So the column should be like:

metric_header

header1,header2,header3

header1,header2,header3

header1,header2,header3

header4,header5,header6

header4,header5,header6

header4,header5,header6

I am using

CONCATENATEX(metrics;metrics[id];metrics[thresold_header];UNICHAR(10);metrics[id];ASC)

 but it does not work cause i need somehow to filter the table for the same id

[kyrpav · Accepted solution]

I fixed it like this

study_kpi_metric_header = 
var metricId=metrics[id]
RETURN 
CONCATENATEX(filter(ALLSELECTED(metrics);metrics[id]=metricId);metrics[thresold_header];UNICHAR(10);metrics[id];ASC;metrics[thresold_category_id];DESC)

[parry2k]

@kyrpav I don't think you can parse the formula, why would you do that though, you can pass the values from the db and have it dynamic but not the whole expression.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[kyrpav]

Cause if i pas the values i need a function that goes in a table and concatenates specific columns for specific groups of rows.
This means that for metric 1 to concatenate all the thresold.
i am now exactly sure how to use calculate and summerize to do this calculation per metric and thresold order since i fix pre thresold this text.