Want new row from existing rows

[AshDil]

Hi,

I have data as follows:

Cateogy in (A,L,I,B) comes under EAST segment, category in (K) comes under WEST segment, category in (N) comes under NORTH segment and category in (K,N) comes under CENTRAL segment (sum of WEST and NORTH segments), so I have written as follows:

I'm not getting the following when using above column

But I want to show as follows

Please help me to do.

Thanks,
AshDil.

[v-deddai1-msft · Accepted solution]

Hi @AshDil ,

You can create the following by enter data:

Then use the following measure:

Measure = CALCULATE(SUM('Table'[Sales]),TREATAS(VALUES(Table2[Category]),'Table'[Category]))

For more details, please refer to the pbix file.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@AshDil , The last statement needs to be in {"K","N"}.

But that will also not work. Create a table with category and segment, in that case, you can repeat the category for the segment. Join new table on category and then you will be able to repeated values