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

Dynamic histograms / segmentation based on measures?

Hi there,

 

I've recently come across a problem I don't know how to tackle. I've been using this (http://www.daxpatterns.com/static-segmentation/) to create a histogram classifying dummy data according to a calculation (for instance, unit price * units) that fall in some kind of bucket.

 

The problem is, I've now come across the need to do it using measures, and I can't display the count of the Measure (which would just return the text value of the name of the appropiate category.


I'm aware of the differences between calculated columns and measures, but still, is there a way to make this work somehow?

Thanks!

 

1 REPLY 1
v-jiascu-msft Super Contributor
Super Contributor

Re: Dynamic histograms / segmentation based on measures?

Hi @evillarreal,

 

A measure is always changing in response to the report. (evaluation context). So counting of a measure is meaningless. Maybe there is a workaround, just maybe. Create a new table to bring all the possible values of a measure together, then we can count them any way.

 

Best Regards!

Dale

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

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 27 members 748 guests
Please welcome our newest community members: