Forum Discussion

taskinosurname's avatar
taskinosurname
Frequent Visitor
3 years ago
Solved

Return "Yes" or "No" based on Multiple Conditions

Hi Everyone,   I'm working on a collision dashboard/report where it would identify whether a driver requires retraining or not. The measure would return a value of "Yes" or "No" based on certain co...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, taskinosurname 

     

    You can try the following methods.
    Sample data:

    Measure:

    Difference = IF(SELECTEDVALUE('Table'[Last Collision Date])=BLANK(),0,
ABS (DATEDIFF (SELECTEDVALUE ( 'Table'[Date] ),
              SELECTEDVALUE ( 'Table'[Last Collision Date] ),MONTH)))
    Retraining Req'd = 
IF (SELECTEDVALUE ( 'Table'[Last Collision Date] ) <> BLANK ()
        && SELECTEDVALUE ( 'Table'[Type] ) = "Non Preventable"
        && [Difference] < 18,
    "Yes",
    IF (SELECTEDVALUE ( 'Table'[Last Collision Date] ) = BLANK ()
            && SELECTEDVALUE ( 'Table'[Type] ) = "Preventable",
        "Yes",
        "No"
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

djurecic's avatar
djurecic
Icon for Super User rankSuper User
3 years ago

Hi taskinosurname ,

 Maybe something like this using OR. Pleas double check the ().

 

Var _Retrain = COUNTROWS(    
    FILTER(
        ALL('NRV Collision'),
        OR(('NRV Collision'[Driver/Reported by] = _Driver && 'NRV Collision'[Type] = "Non Preventable" && 'NRV Collision'[Date].[Date] >=_Date),('NRV Collision'[Driver/Reported by] = _Driver && 'NRV Collision'[Type] = "Preventable"))
    )
)
 
 
Please accept as solution if this has answered the question- thanks!
 
taskinosurname's avatar
taskinosurname
Frequent Visitor
3 years ago

Thank you for the quick response. I appreciate it. 

 

I tried your possible solution with no success. Oddly enough, it's even counting Non-preventables' outside 18 months.