topic Re: Adding a second Filter to a Calculate function in DAX Commands and Tips

Adding a second Filter to a Calculate function

Anonymous — Mon, 02 May 2022 05:09:20 GMT

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?

Re: Adding a second Filter to a Calculate function

amitchandak — Mon, 02 May 2022 06:09:05 GMT

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

Re: Adding a second Filter to a Calculate function

Anonymous — Mon, 02 May 2022 06:21:47 GMT

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

)