Matrix Display Values As

[HenryJS]

Hi all,

Why doesn't 'refcount' below display in the matrix table as the actual value?

i.e. 1, 2 or 3 as per below

It says I can sum, median etc in picture 2 but I dont want to do that I just want it to display as it is in the table in picture 1.

1.

2.

3. matrix 

[tex628 · Accepted solution]

If you know that there is only one refcount for each Candidate Ref you should be able to use Max/Min instead of average and get the correct result. 

Otherwise the correct way to do it would be with a measure.

Measure = SELECTEDVALUE(Table[refcount])

 This returns the refcount if there is only one value available on the current row or BLANK() if theres more than one. 

Br,
J