Forum Discussion

rayinOz's avatar
rayinOz
Helper III
6 years ago
Solved

COUNT and OR statement?

Hello PowerBI users   I'm wanting to use an OR function... ,not sure how to do it... here's the measure:   TotalBooked = CALCULATE(COUNT('Session Report'[Session Attendance]), FILTER('Session Re...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi there. Your formula does not adhere to Best Practices and hence may not be as fast as possible. Here's an optimized version:

     

    TotalBooked =
CALCULATE(
    COUNT('Session Report'[Session Attendance]),
    KEEPFILTERS(
        TREATAS(
            {"Booked", "Attended"},
            'Session Report'[Session Attendance]
        )
    )
)

     

  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    rayinOz You can use this:

    TotalBooked =
CALCULATE (
    COUNT ( 'Session Report'[Session Attendance] ),
    KEEPFILTERS ( 'Session Report'[Session Attendance] = "Booked"
        || 'Session Report'[Session Attendance] = "Attended" )
)

     Or

    TotalBooked =
CALCULATE (
    COUNT ( 'Session Report'[Session Attendance] ),
    KEEPFILTERS ( 'Session Report'[Session Attendance] IN { "Booked", "Attended" } )
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

rayinOz - Either will work:

TotalBooked = CALCULATE(COUNT('Session Report'[Session Attendance]), FILTER('Session Report', 'Session Report'[Session Attendance]="Booked" || 'Session Report'[Session Attendance]="Attended"))


TotalBooked = CALCULATE(COUNT('Session Report'[Session Attendance]), FILTER('Session Report', OR('Session Report'[Session Attendance]="Booked",'Session Report'[Session Attendance]="Attended")))