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

[Anonymous]

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: 

[parry2k]

@Anonymous ha ha, nice feedback. Nice to be a price once in a while, mostly I'm part of thieves  😜

[parry2k · Accepted solution]

@Anonymous wondering if you have a filter that is not allowing you to see the refund  value? Can you hover over the funnel icon on the visual and see what kind of filters are applied and go from there?

[Anonymous]

How did you know that?! You are a prince among thieves, thank you very much. I had duplicated the page which kept the filters although there wasn't any filters visible in the filters window. Lesson learned.