Grouping count by value per category

Question

&nbsp;Hello all,How may I get such results?&nbsp;Will stacked % bars give such? how to group these count range?Thanks alot.&nbsp;Invoice (table) - Value (column)CDTs (table) - Category (column)Vendor (table) - Supplier name (column)

amitchandak · Answer

abadi_89 , for the count you need bucketing 
https://www.youtube.com/watch?v=CuczXPj0N-k
&nbsp;
or
segmentation
https://www.daxpatterns.com/dynamic-segmentation/https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
&nbsp;
Then you can calculate % of sub total - https://www.youtube.com/watch?v=6jTildcV2ho
&nbsp;

v-jingzhang · Answer

Hi&nbsp;abadi_89&nbsp;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 · Answer

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

abadi_89 · Answer

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 · Answer

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

Forum Discussion

Grouping count by value per category

5 Replies

Related content

Grouping Measures into categories

Count of groups of distinct count by group

Fabric & Azure Data User Group Program Requirements & Benefits

Weekly count for each category and then grouping

Counting nulls