Facebook Countif Like name <> null

[epod184]

Hi,

I'm having some trouble setting up some Facebook integration to a Power BI report.

I've followed the extensive Power BI guide, but it appears the Facebook API has changed since then, and it doesn't work the same way.

I am trying to count the amount of "likes" each post recieves, but the Power Query aggregate count function is counting nulls.

is there a way to edit the code below so it only counts if the name is not null?

= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count, "Count of name"}})

aybe something like:

= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count("name"<>null), "Count of name"}})

Thanks!

[Eric_Zhang · Accepted solution]

---

@epod184 wrote:

Hi,

I'm having some trouble setting up some Facebook integration to a Power BI report.

I've followed the extensive Power BI guide, but it appears the Facebook API has changed since then, and it doesn't work the same way.

I am trying to count the amount of "likes" each post recieves, but the Power Query aggregate count function is counting nulls.

is there a way to edit the code below so it only counts if the name is not null?

= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count, "Count of name"}})

aybe something like:

= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count("name"<>null), "Count of name"}})

Thanks!

---

@epod184

Instead of the AggregateTableColumn, you could try to add an custom column as

=Table.RowCount(Table.SelectRows([likes], each [name] <> null))