Count totals for Dynamic Group

[av9]

Hi, 

I have a specific query I am trying to solve for. 

I have a table that looks like this which has Customer, Unique Click Count(Measure), and Segments(Measure). 

I am trying to Group this data like the table and visual below which I have made in Excel.

Index Funds & Stocks	3
Index Funds Only	2
Nothing	42
Stocks Only	2

is this possible in Power BI

The PBIX I am working with: Segments.pbix - Google Drive

[vanessafvg]

in order to place the categorical segments on the axis it needs to be a column not a measure so you will need to do some remodelling of your data.  Did you want a separate table for segments?

[av9]

I have a disconnected Segments table, is there a way I can use this is the measure to group the click counts by segment?

[vanessafvg]

you can only slice a measure by categorical data, you can't slice it using a measure.

There are other ways to model this data but it all depends on why you are trying to do it the way you are, as there are other ways to model this.  What is your objective?

[av9]

The objective is to display whose clicking on articles based on their invested segment. I think I'll try a switch measure and link to the disconnected table using SELECTEDVALUE.