Skip to Content
0

Count of a Merged Dimension

Dec 05, 2016 at 02:01 AM

98

avatar image

Hi,

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.

Thanks,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers