Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
640
Derived Measure field from the distinct count of another field
posted

How can I create a derived measure field dynamically, that calculates the distinct count of another field?

 

For example, take the flat table below that contains raw data depicting a list of men who went to an events and met women:

 

Male_Name

Event_Name

Female_Name

Jack

Concert

Ashley

Jack

Concert

Brittney

Jack

Party

Steph

Jack

Party

Linda

Jack

Mixer

Amber

Bob

Mixer

Amber

Bob

Mixer

Steph

Bob

Party

Ginger

Bob

Party

Gail

Bob

Party

Sophia

Bob

Concert

Ashley

Chad

Concert

Steph

Chad

Concert

Linda

Chad

Concert

Brittney

Chad

Mixer

Amber

Chad

Mixer

Ginger

 

The following Pivot Grid shows the Event_Name as columns, Male_Name as rows and Number_Of_Girls_Met  as the measure which is derived from the distinct count of Female_Names:

 

 

Concert

Party

Mixer

Jack

2

2

1

Bob

1

3

2

Chad

3

0

2

 

How do I make the measure field Number_Of_Girls_Met of type integer, without setting this up in the database?

Parents Reply Children