Forum Discussion
Solved
Adding specialist picture
Hello everyone, I hope you had a happy holiday season with all your loved ones and that this new year 2025 you reach all your goals. I'm a Call Center Supervisor and since last year I have been wor...
Hello lbendlin
Thank you for your advise. I'll keep it on mind.
I have already solved the problem of the formulas, I leave a sample for future reference:
most_effective_specialist = MINX(TOPN(1, ADDCOLUMNS( SUMMARIZE(specialist,[Name]),"Rank",[effective_rank]),[Rank],ASC),specialist[Name])most_effective_specialist_photo = VAR EffectiveSpecialist = MINX( TOPN( 1, ADDCOLUMNS( SUMMARIZE(specialist, specialist[Name]), "Rank", [effective_rank] ), [Rank], ASC ), specialist[Name] ) RETURN CALCULATE( MAX(specialist[PhotoURL]), specialist[Name] = EffectiveSpecialist )
This will fail, but for a different reason. The Power BI service will not have access to the PhotoURL. Instead, consider including the images in the semantic model.
https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/
Hello lbendlin
Thank you for your advise. I'll keep it on mind.
I have already solved the problem of the formulas, I leave a sample for future reference:
most_effective_specialist =
MINX(TOPN(1,
ADDCOLUMNS(
SUMMARIZE(specialist,[Name]),"Rank",[effective_rank]),[Rank],ASC),specialist[Name])
most_effective_specialist_photo =
VAR EffectiveSpecialist =
MINX(
TOPN(
1,
ADDCOLUMNS(
SUMMARIZE(specialist, specialist[Name]),
"Rank", [effective_rank]
),
[Rank], ASC
),
specialist[Name]
)
RETURN
CALCULATE(
MAX(specialist[PhotoURL]),
specialist[Name] = EffectiveSpecialist
)
Hi ajdm2007
It is glad that you have solved the problem, you can accept your answer as a solution so that more user can refer to if they have the similar problems.
Best Regards!
Yolo Zhu