The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
137 | |
106 | |
105 | |
73 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
88 |