How to create different measures with different dimensions in one table

[SNShinde]

Hi All, 

My question is, I have one table.

In that table I have 7 dimensions....

Line of business 

Group 

Category 

Premium type 

Premium type new

Business category 

Par non par

In that table I want to creat two measures like 

1. No. Of Policies 

2. Premium 

In No. Of Policies measure I want total policies based on all 6 dimensions except Premium type new dimension 

In Premium measure I want total premium based on all 6 dimensions except Premium type dimension....

Please help how tackle this...

Regards,

Sagar Shinde 

[MendyS]

Hi @SNShinde 

try to do something like this- 

create two flag,

one  for 6 Dim except Premium type new,

 and Second for 6 dimensions except Premium type dimension.

and when you create the measure enter to set analysis of the flags according to condition.