Need help to interrogate value of a field based on the value selected in a slicer.

[Anonymous]

I have a table called "Projects", which has many columns but the two I'm concerned with for this issue are "Project Name" and "Project ID".  I have a slicer on a report tab, which allows users to select a "Project Name" value and the associated visuals update based on the selection.  For one of the visuals, I have a card overlayed where I want to show a message if the "Project ID" field, for the respective "Project Name" selected in the slicer, is blank.  The measure options I've tried return an error indicating can't determine a single value.  How do I write a measure formula to determine if "Project ID" field is blank for the respective "Project Name" row selected in the slicer?

Thanks for your assistance!

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Does a project name correspond to a project ID? If so, you can try using the following measure:

measure = MAX('project'[project id])

If not,please share sample data and sample output.(Please mask any sensitive data before uploading)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...