Skip to Content
avatar image
Former Member

Count of a Merged Dimension


I am unable to get a count from merged dimensions. My design of report is as follows.

Query 1 : Primary Key (PK1) , Col1, Col2

Query 2 : Primary key (PK2) , Col3, Col4

I have merged PK1 and PK2. Have detailed dimension for for Col2 and Col4 on merged dimension.

The report have Col3 and need a column where Count [Col3] where (Col2 = Col4).

In the measure, i have been using

Count [Col3] where (Detailed Dimension Col2 = Detailed Dimension Col4)..

But the result is #multivalue . Note that Col2 have only one value.

Couldn't figure the error here. Hope somebody can help out.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers