0

NL(Count) Function on a cube

Rodrigo Mourinho

May 25, 2021 18:24

None

Follow

Dear all,

When trying to use the Count (or also the CountUnique) formula, I'm getting the following error message.

What shall I do in this situation? I need to count the number of records.

Thank you and best regards,

Rodrigo Mourinho

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson May 27, 2021 13:14

  There are no such things are Records in a Cube since it is a multi-dimension or tabular model.  There are two ways to get what you need.

  1. Build the Count against the data warehouse.  As a general best practice, most reports using the NL/NF/NP functions should be built against the data warehouse.  It typically performs better and you have tools such as indexing to help speed reporting if needed.  Cubes should be for PivotTables since you need dynamic data in those types of reports.

  2. Build an NL Filter to determine the values you need to count and then use the NF(Filter) as your "table"
  =@NL("filter","Sales","[Bill-to Customer].[City]")
  =@NL("count",C4)