Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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   ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous 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)))
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 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)))