Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
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,
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.
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.