Forum Discussion
Dealing with comments
Hi rmcgrath ,
You can follow the steps below to get it:
1. Create a measure as below
Measure =
VAR _records =
CALCULATETABLE (
VALUES ( 'RecordIDTbl'[RecordID] ),
FILTER (
'Fact_Live_House_Weexx',
'Fact_Live_House_Weexx'
IN ALLSELECTED ( 'Fact_Live_House_Weexx'[slicerappliedfield] )
)
)
RETURN
CONCATENATEX (
FILTER ( 'Comment', 'Comment'[RecordID] IN _records ),
'Comment'[Comment],
","
)2. Apply this new measure onto your card visual to replace the original one
If the above one can't help you get the expected result, please provide some fake data in your tables (exclude sensitive data) with Text format, the visuals Fields settings and your expected result with special examples and screenshots. Later I will check if there is any workaround to achieve your requirement. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Anonymous Thank you!! This is definitely on the right track of what I am trying to do. When I put in all my slicers in the DAX code, I get a weird error? Something about "CONTAINROW" function?
Hi rmcgrath ,
Which fields be applied on the slicers? Could you please provide the related info.
The fields which be applied on the slicers?
It seems that there is some error in the part with red circle in below screenshot...
In order to get a better understanding on your problem and get a suitable solution asap, could you please share a simplified pbix file? It only include some sample(fake) data, the slicers and card visual in it. Please explain your expected result base on your sample data. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hopefully the above link works for you? Please let me know. Also, I attached a screenshot of the expected result / logic. Thank you!
Hi rmcgrath ,
I can't access to your shared file. Could you please grant me the proper permission to it? Thank you.
Best Regards