Count Campus visit with multiple payor

[tanat_inc]

I have data of sale and payor. There are some who paid by Insurance, while some were Selfpay. We want to count those who has payment in both type. That mean the expense are exceeeded insurance limit and we want to help them.

Each customer "hn" in both f_visit_info and f_bill_info table will related to multiple "bill_id" in f_bill_info table , while each "bill_id" will only has one "payor_group".

The original code are below, but the calculate for "Insurance with Selfpay" always return blank.

Insurance With Selfpay = CALCULATE(

   [Campus Visit],

   OR(f_bill_info[payor_group] = "Local Insurance", f_bill_info[payor_group] = "Inter Insurance"),

   f_bill_info[payor_group] = "Selfpay"

)

::: Campus visit definition is Distinctcount(hn,date)

Campus Visit =

VAR _table = SUMMARIZE('f_visit_info','f_visit_info'[visit_date],"distinctcount",DISTINCTCOUNTNOBLANK('f_visit_info'[hn]))

RETURN CALCULATE(

   SUMX(_table,[distinctcount]),

      USERELATIONSHIP('d_date_table'[Date],'f_visit_info'[visit_date]),

      USERELATIONSHIP(d_age_group[ageyear],f_visit_info[visit_ageyear])

)

[v-jingzhang]

Hi @tanat_inc 

Could you share some dummy data and expected result more clearly? Multiple tables and columns are involved in your measures. It's difficult to create a proper measure without knowing the data and relationships between tables. 

If the measure always returns blank, you could remove some filters from the code to check from where it starts to show blank. 

Regards,
Community Support Team _ Jing