Returning Multiple Values with the same date

[htbull_]

I am looking to return 2 values for the titled 10/1/2020, but I receive an error message stating that multiple selections are being returned where a single value is expected. 

In the meantime, I have included a MAX clause in order to pull in one of the two expected values inside of my table. Is there a way to modify the query below in order to bring in two values who share the same date of 10/1/2020?

Query:

CALCULATE(

    SELECTEDVALUE('Member Current Info'[_MemberName],MAX('Member Current Info'[_MemberName])), USERELATIONSHIP('Calendar'[Date], 'Member Current Info'[_JoinedDate]))

[v-hjannapu · Accepted solution]

Hi @htbull_,
Thank you  for reaching out to the Microsoft fabric community forum.

The issue you are facing is because SELECTEDVALUE only returns one value, so it doesn't work when multiple members share the same join date like 10/01/2020. To show all names for a selected date, you can use the CONCATENATEX function along with USERELATIONSHIP to list them.

Members Joined (List) = 
CALCULATE(
    CONCATENATEX(
        VALUES('Member Current Info'[_MemberName]),
        'Member Current Info'[_MemberName],
        ", "
    ),
    USERELATIONSHIP('Calendar'[Date], 'Member Current Info'[_JoinedDate])
)

I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your
reference.

If this answer was helpful and pointed you in the right direction, please consider clicking "Accept as  solution" and kindly give a kudos it may benefit other community members reading this thread. If you have any further questions, feel free to let us know.

Best Regards,
Harshitha.
Community Support Team

[v-hjannapu · Accepted solution]

Hi @htbull_,
Thank you  for reaching out to the Microsoft fabric community forum.

The issue you are facing is because SELECTEDVALUE only returns one value, so it doesn't work when multiple members share the same join date like 10/01/2020. To show all names for a selected date, you can use the CONCATENATEX function along with USERELATIONSHIP to list them.

Members Joined (List) = 
CALCULATE(
    CONCATENATEX(
        VALUES('Member Current Info'[_MemberName]),
        'Member Current Info'[_MemberName],
        ", "
    ),
    USERELATIONSHIP('Calendar'[Date], 'Member Current Info'[_JoinedDate])
)

I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your
reference.

If this answer was helpful and pointed you in the right direction, please consider clicking "Accept as  solution" and kindly give a kudos it may benefit other community members reading this thread. If you have any further questions, feel free to let us know.

Best Regards,
Harshitha.
Community Support Team

[htbull_]

Hey @v-hjannapu 
This method above works great! One adjustment that I'm hoping you would be able to provide is displaying the 2 MemberNames in their own separate rows for 10/1/2020.

Would you have any advice/insights in order to perform this?

[v-hjannapu · Accepted solution]

Hi @htbull_,
Thanks for  the follow up

To display each Member Name on a separate row for a specific date, you don't need to use a CONCATENATEX measure. Instead, simply use a table visual. Add the table visual, then drag in Calendar[Date] and Member Current Info[_MemberName]. Also, ensure that the relationship between these two tables is in an active state for the data to display correctly.

please find attched screenshot for your reference 

I hope this information is helpful.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Regards, 
Harshitha.

[v-hjannapu]

Hi @htbull_,

Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank You.

[v-hjannapu]

Hi @htbull_ ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Thank you.

[v-hjannapu]

Hi @htbull_,

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[speedramps]

I want to help you but your description is too vague. Please write it again.

Download an example PBIX of role play rleationships here

Click here 

You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming

* Please DON'T copy & paste your DAX that does not work and expect us to fathom what you want. (That is just crazy). ‌‌
* Please DO give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.
* Rename columns to user friendly names. Avoid your own system jargon that we may not understand.
* Most importantly please provide example input data as table text (not a screen print) so helpers can import the data to build a solution for you. (Learn how to share data below)
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Remember not to share private data ... we don't want you to get into trouble. ‌‌
* Please click the thumbs up button for these helpful hints and tips. Thank you.

Learn how to attach data in the forum using OneDrive:-
* Save your file in a OneDrive folder
* Right click on the file and click the “Share” blue cloud icon
* Click the bottom “Copy” button
* Click” Anyone with link can edit”
* Click “Can Edit”
* Click “Can View”
* Click “Apply” button
* Click “Copy”
* Paste the generated link via the forum, email, chat, or any other method.
* Helpers can then download your data, build a solution and share it back.

Learn how to attach data in the forum using Dropbox:-
1. Open Dropbox: Access the Dropbox folder on your computer or through the Dropbox web interface.
2. Select File/Folder: Find the file or folder you want to share.
3. Click Share (or Get Link): Look for a "Share" option or a similar "Get Link" option.
4. Choose Permissions: Decide whether to allow "view only" or "view and download" access.
5. Copy and Share: Copy the generated link and share it with anyone via the forum, email, chat, or any other method.