Projects Online - Return Top Risk Id per Project

[CobusEllis]

Hi,

I am working with Projects Online data.
I want to return the RiskId for the risk with the highest score per Project.

Data entities:
Projects: Project Id etc (Add column here)
Risks: Project Id, Risk Id, Impact, Probability, Score = Impact * Probability

With the top Risk ID in the Projects table I can retrieve all needed information with lookups...

Please help with tthe correct DAX expression or ideas to try!

[v-jiascu-msft · Accepted solution]

Hi @CobusEllis,

Seems you'd like to have a calculated column, please try the formula below and check out the demo in the attachment.

RiskWithHighestScore =
CALCULATE (
    MAXX (
        TOPN ( 1, 'Risks', 'Risks'[Impact] * 'Risks'[Probability], DESC ),
        Risks[Risk ID]
    )
)

Best Regards,
Dale

[CobusEllis]

Works great, thank you!