NTHCOUNT

Returns the number of bottom most descendant elements within a specific parent element within a specified dimension hierarchy.

js

NTHCOUNT(dimension, hierarchy, parent)

NTHCOUNT(dimension, hierarchy, parent)

Parameters

dimension - The name of the dimension.
hierarchy - The name of the hierarchy.
parent - The name of the parent element.

Examples

js

NTHCOUNT("Time", "Default", "2018")

NTHCOUNT("Time", "Default", "2018")

Note: This will return 365 assuming the Time dimension has a day level granularity.