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
FBergamaschi's avatar
FBergamaschi
Super User
11 months ago

To obtain what you are looking for, there are two ways:

 

1 - all in DAX

 

2 - getting help from the tables

 

To make it fast, I choosed option 2, here is the file for you to inspect

 

https://drive.google.com/drive/folders/1ygPYgruaZZy8Spvekfe4j6qd_N2eng7n?usp=sharing

 

If you need a full DAX solution keeping your tables, I shall look into that, I think it is feasible but will need a bit more time

 

Best

 

If this helped, please consider giving kudos and mark as a solution

mein replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Jyaul1122's avatar
Jyaul1122
Helper III
11 months ago

FBergamaschi 

I would appreciated via DAX. Thanks

    • 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