Visualization without linked dimension

[Former Member]

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.

[JohnL]

Hi Jaywant,

Do you have a screenshot of this?

[Matthew_Shaw]

I think you need to apply an exception aggregation. This is very helpful article on this

https://www.sapanalytics.cloud/resources-applying-aggregation/ (worth reading and a bookmark even if it doesn't solve the issue!)

Regards, Matthew