cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaroslavnaumov Frequent Visitor
Frequent Visitor

Segment problems

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

2 REPLIES 2
jaroslavnaumov Frequent Visitor
Frequent Visitor

Re: Segment problems

Hi!

 

UP!

 

Please can some one reply .

Thanks!

 

Best regards

Jaroslav

Highlighted
Community Support Team
Community Support Team

Re: Segment problems

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.