Forum Discussion

Jyaul1122's avatar
Jyaul1122
Icon for Helper III rankHelper 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
    Icon for Helper III rankHelper 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