Grouping count by value per category

[abadi_89]

Hello all,

How may I get such results?

Will stacked % bars give such? how to group these count range?

Thanks alot.

Invoice (table) - Value (column)

CDTs (table) - Category (column)

Vendor (table) - Supplier name (column)

[amitchandak]

@abadi_89 , for the count you need bucketing

https://www.youtube.com/watch?v=CuczXPj0N-k

or

segmentation

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

Then you can calculate % of sub total - https://www.youtube.com/watch?v=6jTildcV2ho

[abadi_89]

Thank you @amitchandak ,
I managed to make the bucketing but couldn't manage to after? it won't go to the visual!
Any ideas?

[v-jingzhang]

Hi @abadi_89 

It seems your Segmentation is a measure. In order to use segmentation as category in a bar chart, you need to create a calculated column for segmentation instead of a measure because measures cannot be put in Legend or Axis fields of a chart. For example,

Regards,

Jing

[abadi_89]

Thank you!

Now it make sense, any idea how to create that column if the region is in another table?

What I have is:

Invoice (table) - Value (column)

CDTs (table) - Category (column)

Vendor (table) - Supplier name (column)

[v-jingzhang]

What is the relationship between these tables? If you create proper relationships on columns in these tables, this should also work.