Measure from a variant column

[jorgen82]

Hello

I am having a table like the below which keep info for some servers. 

.

In order to be able to present it with a table, i unpivot it, so i have the Attribute and the Value on different columns.

My problem is if i want to present a specific value as an average (eg the Available Physical Memory). I am able to get the value by filtering the specific attribute, but it does not return a number (and i coudln't make it to return a number), but most importantly i cannot get average value.

Is it possible? I cannot use the Average, since it cannot be used with no numeric values. The only way i found is to create a calculated column IFERROR(FIXED(tblPhysicalServerDetails[Value];0;1);""), in order to get the numeric values, and make my measures based on that column. Is there anything else i could try? I can use the calculated column "solution", but i also wanted to learn if there is another solution.

Thanks,

George

[v-yuta-msft · Accepted solution]

Hi jorgen82,

Click Query Editor-> Add Column-> Custom Column, then create a custom column using M code like pattern below:

= try Number.ToText(Number.FromText([Value])) otherwise "" 

 

Regards,

Jimmy Tao