Skip to Content
0
Former Member
May 18, 2018 at 01:13 PM

Visualization without linked dimension

108 Views

I am trying to create a report with two models linked on a dimension. I need the count of records and am using calculated measure for this (count).

When I add the dimension from the secondary model (not the linked dimension), the count is incorrect. However, the count is correct if I use the linked dimension in visualization. I realized that the count is average based on the linked dimension when the other dimension is used for visualization.

Example -

Primary model -

Column A, Column B, Column C(measure)

Secondary model -

Column B, Column D (dimension)

Primary and secondary models are linked on Column B (linked dimension).

Result of visualization -

Column B vs Calculation count column - 100 (total across column B values)

Column D vs Calculation count column - 45 i.e. less than 100. Here count against each Column D value is average of corresponding results for Column B

I need to know how to get rid of the averaging being done for the other dimensions.