cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
datanau001
Helper III
Helper III

Create segment from a count measure

Dear all,

 

I’d like to ask your help with the following:

 

“Times accepted” is a measure that I created to count how many times an SR_Number was accepted.

PB_Table.jpg

So for each SR_Number I know the times it has been handled and now I want to segment this measure like:

 

Times accepted = 1

Times accepted = 5

Times accepted > 12 and so on… ( there could be several segments )

 

However, I’m not sure how to create the segmentation based on this measure (count).

 

Would you please suggest how I can achieve this?

 

Thank you

Marcelo

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @datanau001 ,

 

This is a post I replied to earlier, which is very similar to your issue.
My solution is to create a separate table of measure categories, and then create a new measure, the previous measure will be embedded in the new measure.

Screenshot 2021-04-05 163844.png

 

 

Post: Count Users and Company (Between this value)

 

 

Best Regards,

Stephen Tao

 

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

View solution in original post

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

Hi @datanau001 ,

 

This is a post I replied to earlier, which is very similar to your issue.
My solution is to create a separate table of measure categories, and then create a new measure, the previous measure will be embedded in the new measure.

Screenshot 2021-04-05 163844.png

 

 

Post: Count Users and Company (Between this value)

 

 

Best Regards,

Stephen Tao

 

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

View solution in original post

amitchandak
Super User IV
Super User IV

@datanau001 , Refer to my video on how to create dynamic segmentation :https://youtu.be/CuczXPj0N-k

 

or

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hello Amitchandak,

I was looking into your previous information but couldn't relate it to my case. This is because, for some of the solutions, I need a specific column that I don't have in my dataset.

 

My measure "Times accepted" is based on counting the status ="Accepted" which gives the result per each SR_Number.

See below:

PB_Table_2.jpg

So my next step would be trying to create a column that would be based on this "time accepted" measure and show it segmented.

In this case, the segment would be called "Accepted Times = 5"

 

Regards

Marcelo

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors