Reply to Message

Post Message

Subject

Event summary

Event location

Event street

Event city

Event state

Event country

** Required: Start date

**Required: End date

Event Additional

Event MetaData

Event Status

Body

never-displayed

Hint:

@ links to members

Replying to:

Thanks for your reply but I can not write condition for more than 200 unique Projects.

VAR Selection = VALUES ( Dim[Project] )

VAR SelectionExpandedA = UNION( Selection, {"Include A"} )

VAR SelectionExpandedB = UNION( Selection, {"Include B"} )

VAR SelectionExpandedAB = UNION( Selection, {"Include A"},{"Include B"} )

VAR Result=

IF (

("P1" IN Selection || "P2" IN Selection) && ("P3" IN Selection || "P4" IN Selection),

CALCULATE( MAX ( Facts[Risk Value] ), KEEPFILTERS(Facts[Project] IN SelectionExpandedAB )),

IF (

"P1" IN Selection || "P2" IN Selection,

CALCULATE( MAX ( Facts[Risk Value] ), KEEPFILTERS(Facts[Project] IN SelectionExpandedA ) ),

IF (

"P3" IN Selection || "P4" IN Selection,

CALCULATE( MAX ( Facts[Risk Value] ), KEEPFILTERS(Facts[Project] IN SelectionExpandedB ))

)

))

RETURN Result

Could you please do needfull ? Thanks