Forum Discussion

av9's avatar
av9
Helper III
4 years ago

Count totals for Dynamic Group

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 & Stocks3
Index Funds Only2
Nothing42
Stocks Only2

 

is this possible in Power BI

 

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

Need Help

4 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    4 years ago

    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's avatar
      av9
      Helper III
      4 years ago

      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's avatar
        vanessafvg
        Community Champion
        4 years ago

        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?