Distinct count of Two Columns Plus filter not blank 3rd column

[Invesco]

Hi Experts

I am trying to count the distinct values in the following two column crm_call_name and crmf_hcp_id and then where crmf_clm_presentation_slide_id is not blank... cannot see my error

Measure 

Calls With #eDetails = CALCULATE(

                        DISTINCTCOUNT(eda_edetailing_slides_used[crm_call_name]),eda_edetailing_slides_used[crmf_hcp_id],eda_edetailing_slides_used[crmf_clm_presentation_slide_id] <> BLANK())

[Greg_Deckler · Accepted solution]

@Invesco Try:

Measure =
  VAR __Table = FILTER('eda_edetailing_slides_used', [drmf_clm_presentation_slide_id] <> BLANK())
  VAR __Column1 = SELECTCOLUMNS(__Table,"__Column",[crm_call_name])
  VAR __Column2 = SELECTCOLUMNS(__Table,"__Column",[crmf_hcp_id])
RETURN
  COUNTROWS(DISTINCT(UNION(__Column1, __Column2)))

[Invesco]

Part 2 if your interested
Additional Filter to TRICKY DAX - Microsoft Power BI Community

[Invesco]

Excellent thanks Greg

[Invesco]

Also not working

Calls With #eDetails = CALCULATE(

                            COUNTROWS(

                                GROUPBY(eda_edetailing_slides_used,

                                eda_edetailing_slides_used[crm_call_name],

                                eda_edetailing_slides_used[crmf_hcp_id]

                                )

                            ),

                        eda_edetailing_slides_used <> BLANK())