Display information if and only if one selection is selected

[Zakaria_1980]

Hello,

please I have the list of project manager names per project ==> Column Called Project Manager Name

Table called : Tbl1.

i've inserted card to display the name of PM once the project name is selected. when we select only 1 project , the name of the project manager is displayed. however, when i selecting multiple projects, it displays always one project name.

i would like please your support, whenever we have multiple selection in project name, the card will be kept empty and if we select only 1 project, it will display the name of the PM.

Thanks in advance.

[Anonymous · Accepted solution]

Hi @Zakaria_1980 ,

Check the formula below.

Measure = IF(DISTINCTCOUNT('Table'[Project])>1,BLANK(),SELECTEDVALUE('Table'[PM_name]))

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Zakaria_1980]

please where i have to put this mesure as filter ?

under Project Name filter or in Project manager name card ?

and what criteria should i choose for this measure please.

please help me with steps to follow.

br,

[Greg_Deckler]

IF(HASONEVALUE('Table'[Project]),MAX('Table'[Project]),BLANK())

[Zakaria_1980]

I've tried, but I guess you have to support me a little with steps.

for that please find below the screenshot of the mesure that has supported me with:

below also screenshot of my dashboard for the list of project names and where you displyd the name of the project manager:

Thank you in advance.

[Zakaria_1980]

 i've tried but i guess you have to support me a little bit with steps.

for that please find below the screenshot of the mesure that you have supported me with:

below also screenshot from my dashboard for the list of project names and where i displyed the name of the project manager:

Thanks in advance.