Set analysis concept with text

[#1]

I am over analyzing what I thought was a simple task...

For those of you in healthcare you are probably familiar with Meaningful Use.  I have an excel spread sheet that has all the details on the measures for Stage two.

I would like to create an informative tab in my MU Dashboard that lists breaks down the details of each measure.  I loaded the excel spread sheet into my load script and now I can't figure out how to use it.

I am trying to use set analysis on text fields and failing miserably...

The concept I would like to use is simple...

sum({<Measure={'P208'}>}Requirements)

The desired result is a blurb in the spread sheet :

Measure

Definition

Requirements

P208

Record demographics

More than 80% of all unique   patients seen by the EP have demographics recorded as structured data.

But I keep getting '0' and I am assuming its because I can't SUM the Requirements....

Any guidance would be greatly appreciated

[Carlos_Reyes · Accepted solution]

Use MaxString instead of Sum... although perhaps there are more efficient functions to deal with strings but I always use MaxString when I need to get that kind of result.

[Aurelien_Martinez]

Hi,

Use Concat or Only like:

Only({<Measure={'P208'}>}Requirements)

OR

Concat({<Measure={'P208'}>}Requirements)

Regards,

Aurélien

[#4]

Thanks Carlos, that worked perfectly!