cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
av9
Helper III
Helper III

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). 

 

av9_0-1632981048011.png

 

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

 

av9_1-1632981387783.png

is this possible in Power BI

 

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

4 REPLIES 4
vanessafvg
Super User
Super User

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?

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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

av9_0-1632989111710.png

 

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?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!