Forum Discussion

Jyaul1122's avatar
Jyaul1122
Helper III
11 months ago
Solved

Include based on slicer

Hello All, I have two tables dimenstion and fact : Which are related with Project column(one to many). And I have  Project  slicer (from Dimension table). I wrote measure: Risk value=m...
Need Help
Jyaul1122's avatar
Jyaul1122
Helper III
11 months ago

FBergamaschi 

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