Forum Discussion

rmcgrath's avatar
rmcgrath
Advocate II
2 years ago

Dealing with comments

So I have two Fact tables.  Ultimately, I want to have a card with comments based on the GroupID from one table and the RecordID from the other table, which also contains the comments (1 comment per ...
Need Help
rmcgrath's avatar
rmcgrath
Advocate II
2 years ago

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?

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • rmcgrath's avatar
    rmcgrath
    Advocate II
    2 years ago

    sample_file 

    Hopefully the above link works for you?  Please let me know.  Also, I attached a screenshot of the expected result / logic.  Thank you!

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi rmcgrath ,

      I can't access to your shared file. Could you please grant me the proper permission to it? Thank you.

      Best Regards

      • rmcgrath's avatar
        rmcgrath
        Advocate II
        2 years ago

        Anonymous I need your email to add you