Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Adding a second Filter to a Calculate function

Hey guys,

I've got the following DAX formula:

Visits My Pension = CALCULATE(
DISTINCTCOUNT('OD - All Page Visits Portal'[VISIT_ID]),
FILTER('OD - All Page Visits Portal','OD - All Page Visits Portal'[PAGE_HOSTNAME]="my.pension.nl")
)

I'd like to add a second page to the filter: All Page Visits Portal'[PAGE_HOSTNAME]="my.pension.nl#"
So all the visit_id's of both pages are calculated. How can I add the second filter?

CALCULATE
DAX
Filter
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,

     

    Visits My Pension = CALCULATE(
    DISTINCTCOUNT('OD - All Page Visits Portal'[VISIT_ID]),
    FILTER('OD - All Page Visits Portal','OD - All Page Visits Portal'[PAGE_HOSTNAME] in { "my.pension.nl", "my.pension.nl#" } ) )
    )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,

     

    Visits My Pension = CALCULATE(
    DISTINCTCOUNT('OD - All Page Visits Portal'[VISIT_ID]),
    FILTER('OD - All Page Visits Portal','OD - All Page Visits Portal'[PAGE_HOSTNAME] in { "my.pension.nl", "my.pension.nl#" } ) )
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous ,
    can also do this 

    Visits My Pension = CALCULATE(
    DISTINCTCOUNT('OD - All Page Visits Portal'[VISIT_ID]),
    FILTER('OD - All Page Visits Portal','OD - All Page Visits Portal'[PAGE_HOSTNAME]="my.pension.nl" || 'OD - All Page Visits Portal'[PAGE_HOSTNAME]="my.pension.nl#")
    )