Populate multi-row card from table which is filtered based on a measure

[thomsog1]

Hi all,

I am fairly new with DAX expressions so apologies if this is an fairly straight forward task.

I have 2 tables "Project Scores" and "Project Feedback"

"Project Scores"

Name	Project	Score
Person #1	Project #1	3
Person #2	Project #1	5
Person #3	Project #2	3
Person #4	Project #2	5
Person #5	Project #2	0
Person #6	Project #3	3
Person #7	Project #3	4
Person #8	Project #3	3
Person #9	Project #3	0
Person #10	Project #3	1

"Project Feedback"

Score	Feedback
0	• Comment A
0	• Comment B
0	• Comment C
1	• Comment D
1	• Comment E
1	• Comment F
2	• Comment G
2	• Comment H
2	• Comment I
3	• Comment J
3	• Comment K
3	• Comment L
4	• Comment M
4	• Comment N
4	• Comment O
5	• Comment P
5	• Comment Q
5	• Comment R

I also have a measure called [Average Score] which averages the Score column in "Project Scores". This is filtered based on Project Name using a slicer.

I'm trying to create a multi-row card which is populated with the Feedback column depending on the Average Score measure. So for example if my slicer was selecting Project #1, my measure would have a value of 4 and therefore I would want my multi-row card to include the following:

• Comment M

• Comment N

• Comment O

I have tried created calculated tables and calculated columns, however I've just learned these are calculated on load and dont apply values from slicers etc. so arent dynamic. Subsequently I've tried, If statements, Filters and other ideas, but since I'm fairly new with DAX, I'm getting nowhere fast and clearly missing something fundamental for what at first glance appears to be a fairly simple problem.

Any help at all would be greatly appreciated!

[richbenmintz · Accepted solution]

Hi @thomsog1 ,

I you could create a measure that returns the concatentation of the feedback based on the selected projects average score like, 

Feedback Comments = 
CONCATENATEX(FILTER('Project Feedback', [Score] = [Average Score]), [Feedback], UNICHAR ( 10 ))

 I would then use a regular card visual

 

Hope that helps,

[thomsog1]

Thanks for the quick reply! That will do what I need.

I had looked at using the FILTER function, but couldnt work out how it actually worked. I guess you're using CONCATENATEX to basically turn it into a single value as opposed to a table (which I think was what a bunch of the errors I was getting back were about)...