Sum of the result of a field and measure

[dranjbar]

Hi All,

I've created this table which gives me the total value that I am looking for which is 44 here but I can not figure out how to get this result into a KPI/measure. I believe its because its using both a field and a measure to give me the result value.

I've tried a few different combinations using aggr which I believe is the correct method but cant seem to get to a solution.

My field is: TestName

My measure is: count({<mTestResults={1}>} distinct [Patient ID])

Thought this might work but it didnt: Sum(Aggr(TestName, count({<mTestResults={1}>} distinct [Patient ID])))

I believe it may be because my measure is nested with a count? I'm not too sure.

Any help would be appreciated.

Thanks

[Vegar · Accepted solution]

You swapped the order  of the aggr parameter. Try this expression:

Sum(Aggr(count({<mTestResults={1}>} distinct [Patient ID]),TestName))

[dranjbar]

Yep that did the trick, can't believe I missed that.

Thanks!