Forum Discussion

Maithilitiwari's avatar
Maithilitiwari
Frequent Visitor
2 years ago
Solved

IF Statement

Recurring Bookings = IF( ISFILTERED(Renewal[RENEW FLAG]) && SELECTEDVALUE(Renewal[RENEW FLAG]) = "NEW BUSINESS" && SELECTEDVALUE(BusinessMix[Bookings by Class]) IN {"License Support", "Hardware S...
Need Help
  • Maithilitiwari's avatar
    Maithilitiwari
    2 years ago
    Recurring Bookings =
    IF(
        ISFILTERED(Renewal[RENEW FLAG]) &&
        SELECTEDVALUE(Renewal[RENEW FLAG]) = "NEW BUSINESS" &&
        COUNTROWS(
            FILTER(
                ALLSELECTED(BusinessMix[BookinLicense Support", "Hardware Support", "Subscription", "SAAS", "BCS", "Consumption"}gs by Class]),
                BusinessMix[Bookings by Class] IN {"
            )
        ) = 6 &&
        COUNTROWS(ALLSELECTED(BusinessMix[Bookings by Class])) = 6,
        "True",
        "False"
    )
     
     
    This code is working
    So if i select all of these
    ("License Support", "Hardware Support", "Subscription", "SAAS", "BCS", "Consumption") i get true and if anything is missing or nothing is selected it gives me false
_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Where is your issue?

Maithilitiwari's avatar
Maithilitiwari
Frequent Visitor
2 years ago

I am getting true only when License Support is selected apart from that i am getting false