how to get distinct values in dimensional level

[lakshman1031]

Hi All,

I have dimensions like Category, ID and Date fields.

In category i have Category1, Category2, Category3 like that and i am taking pie chart and i am taking two values from Category field, I am trying to create Pie chart using below expressions.

Dimension = Pick(Match(Category, 'Cat1',cat2'),'Cat1','Cat2') and 

Measure = Count(Date)

I want to show  distinct ID values of the data in country wise in Pie chart.

Can you please suggest me how to do this scenario.

Thanks & Regards,

Lakshman

[sbaro_bd]

Hi @lakshman1031,

For your dimension, use a IF statement with NULL values when FALSE, like this : 

IF( Match(Category, 'Cat1','Cat2'), Category, null())

On your dimension, disable option 'include null values'.

Regards.