Forum Discussion

Regular Visitor

4 years ago

Solved

Group by Measure - Calculated categories

Hi,

I am running an analysis on some sales figures, and I have the following table:

Product WoW Delta WoW Category

A 250 Increase

B -300 Decrease

C 100 Increase

D -200 Decrease

Column "WoW Delta" and "WoW Category" are measures I calculated.

What I would like to do is create a table like this:

Increase 350 ** basically adding products A and C

Decrese -500 ** bascially adding products B and D

But I've read in several places that measures cannot be used in groups.

Is there a way to create this table?

Any way

Anonymous
4 years ago
Hi hhdez ,

You will need the [WoW Category] to be a column.
Then you could use CONCATENATEX() function to create a new category group.

Column = CONCATENATEX(FILTER('Table','Table'[WoW Category]=EARLIER('Table'[WoW Category])),'Table'[Product],",")

Best Regards,

Jay

3 Replies

jaipal
Resolver III
4 years ago
hhdez you don't need a measure here. Just add your columns in correct fields.

let me know if it doesn't work
- hhdez
  Regular Visitor
  4 years ago
  Hi,
  I tried doing this but I can't seem to be able to move it 'WoW Category' as a row since it is a measure I calculated. Do you know if there is a way around this?
Anonymous
Not applicable
4 years ago
Hi hhdez ,

You will need the [WoW Category] to be a column.
Then you could use CONCATENATEX() function to create a new category group.

Column = CONCATENATEX(FILTER('Table','Table'[WoW Category]=EARLIER('Table'[WoW Category])),'Table'[Product],",")

Best Regards,

Jay

Related content