Aggr Count Distinct and Ignore Dimension

[cmorri1988]

Hi there,

Please can I ask how I would get the results of the measure but across all dimensions (Mth-Year)?

Pivot Dimensions and Measure attached.

• Dimension: Authority ID
• Dimension: Mth-Year
• Measure: =Aggr(count(distinct [Mth-Year]),[Authority ID])

It is only showing within the first Mth-Year for which there was data for each authority.

With Thanks

[sunny_talwar]

Maybe try this

=Aggr(NODISTINCT Count(DISTINCT [Mth-Year]), [Authority ID])