DV Total Count always calculated in the highest level

Summary

DV Total Count always calculated in the highest level

Content

Hello,

I am using visual analyzer Version 12.2.1.1.0.

Module Description:

FactA - ColA, ColC

FactB - ColB, ColA

DimA - ColC, ColC_Desc

 

FactA joins FactB on FactA.ColA = FactB.ColA

FactA joins DimA  on FactA.ColC = DimA.ColC

MeasureFactB = count(distinct ColB)

 

I'm using the visual analyzer with the following combination:

ColC_Desc, MeasureFactB

 

The measure (MeasureFactB) presents the total count of ColB in the fact table and not group by ColBDesc.

For Example:

The presented results:

ColC_Desc    MeasureFactB

ABC                    10

DEF                    10

XYZ                    10

 

The expected results:

ColC_Desc    MeasureFactB