Data in visual not coming through from Custom Column in Power Query

Hello, 

I have 2 near-identical custom columns in Power Query as follows:

Insight_refund = if List.AnyTrue(List.Transform({"refund"}, (substring) => Text.Contains([Message], substring))) then "Refund" else ""

Insight_credit = if List.AnyTrue(List.Transform({"credit"}, (substring) => Text.Contains([Message], substring))) then "Credit" else ""

These columns both work correctly: 

I would like to see the YoY difference in a line graph so created these measures to populate the y axis: 

Insight_credit_count =

CALCULATE(  

DISTINCTCOUNT(hotjar[ID_Ref No]),hotjar[Insight_credit] IN { "Credit" }  )

Insight_refund_count =

CALCULATE(  

DISTINCTCOUNT(hotjar[ID_Ref No]),hotjar[Insight_refund] IN { "Refund" }  )

 

The issue is that data from insight_refund_count or insight_refund isn't transferring so the tables are blank: 

 

In comparison, the insight_credit_count works great:

 

I am using a date table that is linked to this current table which is an Excel workbook hosted locally. 

 

Instead of "Credit" & "Refund", I have also tried using 1 and then using the main insight_xx columns to sum/count but it the same result is happening. 

 

I can't see a way to upload a file but here is a snapshot of what the data behind looks like: