topic Re: Draw the distribution in bins of a total per category in DAX Commands and Tips

Draw the distribution in bins of a total per category

Anonymous — Mon, 09 May 2022 12:06:51 GMT

Hello,

I hope that I'm not redundant. I tried to find an answer, but I could not ...

Let's say that I have a table like this :

Object_Id	Observation_Id	Value
A	101	12
B	102	27
C	103	0
A	104	1
C	105	125
A	106	17

My first goal is to add values according to their Object_Id. This thing, I'm able to do it thanks to a Quick Measure - Total per Category. Then, I want to study the distribution of the values : I want to draw a histogram with in x-axis some bins of my values, and in y-axis the number of values in these bins, but with each Object_Id appaearing only once (and with the value of the per category total). This step, I couldn't do it properly.

My first idea was to create a sub-table with the results of my first goals. But when, by necessity, I have to add a filter on Observation_Id (for example, using only observations with and Id > 103), the sums are still on all observations and not on the sub-selection that I wanted (I do this one by selecting a time range on a Time Brush graph). How could I do it correctly ?

Thank you for your time.

Re: Draw the distribution in bins of a total per category

Whitewater100 — Mon, 09 May 2022 13:57:41 GMT

Hi:

Is this what you are looking for? I hope this helps..

https://drive.google.com/file/d/1NRA0JcfZTFAW2rByw_ul8iUY4noLUwoG/view?usp=sharing

Re: Draw the distribution in bins of a total per category

Anonymous — Mon, 09 May 2022 14:15:20 GMT

Hello, thank you for your answer !

On the Min of Object_ID by Value graph, I was more thinking of a graph that use only the sum of each Object_Id, for example something like that with my data :

But this graph updating if I use a slicer to select only some Observation_Id, so modifying the sums.

Thank you again !

Re: Draw the distribution in bins of a total per category

Anonymous — Mon, 16 May 2022 08:48:31 GMT

Hi Anonymous ,

Create a column instead of a measure:

sum of each Object_Id = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Object_Id]))

Then you could use the column as x-axis and count of ID as value:

Best Regards,

Jay