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 Vis...
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#" } ) )
    )

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#" } ) )
)