I don't think that's the same thing I'm asking for Nikolov. I specifically need a field that would show up in the "Measures" section of the tree that you will just have to drag into the measures section of the pivot grid. That Field should be, in sql terms, a DISTINCT COUNT of an existing field.

Hello,

If you are using XmlaDataSource you need to create/set up this in BI studio.

If the case is with FlatDataSource if you want to deal with this with less effort you'll need at least numeric property exposed by your data object, so you can create a measure for that property. That's because of the way the default measures are created.

<olap:FlatDataSource.CubesSettings> 

    <olap:CubeMetadata

        DataTypeFullName="YourDataClassFullName"

        DisplayName="My Data">

        <olap:DimensionMetadata SourcePropertyName="YourNumericPropertyName"

                                            DimensionType="Measure"

                                            DisplayName="DisplayNameForYourMeasure"

                                            DisplayFormat="{}{0}"

                                            AggregatorType="Count"/>

    </olap:CubeMetadata>

</olap:FlatDataSource.CubesSettings>

This code will create a measure that will act in the way you have described and will calculate the common count of the members involved.

However, if it's not acceptable for you to create another property for your class then you'll need to create a custom aggregator as Yanko has proposed. It seems the online sampe is missing the code of the custom aggregator, so I have attached it. In your case the TopCountCache class just need to store the absolute number of AddCount method is called.

Regards.
Plamen.

Plamen, your suggestion sounds more like what we need. This is what I did so far. All the default fields show up, I did not get any errors BUT I don't see the measure "Female Count" showing up on the data selector. Am I missing anything? I'm using code behind because I'm having a hard time getting the XAML binding to work, that'll be a separate post later.

CubeMetadata cubeMetadata = new CubeMetadata();
    cubeMetadata.DataTypeFullName = typeof(BoyMeetsGirl).FullName;               
    cubeMetadata.DisplayName = "Boy Meets Girl";
  cubeMetadata.DimensionSettings.Add(
        new DimensionMetadata(){
            SourcePropertyName ="Female_Name",
      DimensionType = DimensionType.Measure,
      DisplayName = "Female Count",
      DisplayFormat ="{}{0}",
      AggregatorType = AggregatorType.Count });

FlatDataSource dataSource = new FlatDataSource();
dataSource.ItemsSource = DatingViewModel.BoyMeetsGirlObservableCollection;
dataSource.CubesSettings.Add(cubeMetadata);
pivotDataSelectorSampleDetails.DataSource = dataSource;
pivotGridSampleDetails.DataSource = dataSource;

Looks like something that I am looking too. I have a class Customer. How can I expose the property(Amount) of Order as a measure, if I create a Cube out of List of Customers(basically FlatDataSource).

public class Customer

{

  string Name {get; set;}

  Order CustOrder {get; set;}

}

public Order

{

  string OrderNum {get; set;}

  double Amount {get; set;}

}

Plamen, YOU ARE A GENIUS!!!

This is exactly what I need. Although I was hoping that your first suggestion would work, because it made a lot of sense. I am happy with the solution you've provided. It's given me extra things to add to the application.

Thank You!!!

I have modified the TopCountAggregator so it can follow different behaviors now. You can find a working sample attached which I hope will cover your needs.

Best regards.
Plamen.

Hello,

The cube settings should be added before items source is set because all metadata is processed when items source is set.

FlatDataSource dataSource = new FlatDataSource();

dataSource.CubesSettings.Add(cubeMetadata);
dataSource.ItemsSource = DatingViewModel.BoyMeetsGirlObservableCollection;

Regards.
Plamen.