Need Code for Two column

[MrJanjua]

Hi, I have two columns with Items and Category

Items       Category

Milk             Bakery

Bread       Bakery

Water       Shop

Biscuets   Shop

Nugets      Bakery

I wants to show two pia-cart with Bakery Items separate and Shop Items separate. i need a expression for this

[Dalton_Ruer]

Here you go. the expression I used is in the label for the pie charts 

I used this sample code:

Load * Inline [
Items , Category, Value
Milk, Bakery, 40
Bread, Bakery, 30
Water, Shop, 45
Biscuets, Shop, 55
Nugets, Bakery, 20
];

And I created a Master Dimension for the Category and defined the colors then set the pie charts to color by the Category dimension

[MayilVahanan]

Hi 

Try with set analysis

Exp1: Count({<Category = {'Bakery'}>} Distinct Items)

Exp2: Count({<Category = {'Shop'}>} Distinct Items)

[MrJanjua]

Dear!

I need this in Demission (Expression) not in Measure. 

[MrJanjua]

I have a lot of items and have 4 categories. So wants to make 4 Charts separately, One thing more items adds frequently they are not fixed