Segment problems

[jaroslavnaumov]

Hi!

I have a question, I have column with segments(Convenience, Moderation, Extreme, Select, All Season, Regular, Productivity, Youth).

I need put it into different groups. I need calculate it that: if segment sales are below avarage then put the segments into the group "other" if more then just show out.

Thanks!

Best regards,

Jaroslav

[v-juanli-msft]

Hi @jaroslavnaumov 

"Convenience, Moderation, Extreme, Select, All Season, Regular, Productivity, Youth" are columns' header, right?

Where is "segment sales"?

Per this requirement, "if segment sales are below avarage then put the segments into the group "other" if more then just show out",

It can be achieved by a measure with DAX like:

Measure=IF([sales]<[average],"other",[this column])

But it may not correct for it can't apply to your scenario.

Please show an example data and expected result for better analysis.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jaroslavnaumov]

Hi!

UP!

Please can some one reply .

Thanks!

Best regards

Jaroslav