Forum Discussion

iloobi's avatar
iloobi
New Member
3 years ago
Solved

Merging fields to count as one

Hello,

 

I am very new to PowerBI and potentially this is an easy question so my apologies if it seems stupid to ask this. I have data in this format

 

Project namePopulation served (1st choice)Population served (2nd choice)Population served (3rd choice)
DancingWomen and girlsChildren and Youth 
SingingChildren and youthLow income individualsIndigenous
ReadingIndigenous  
WritingRacialized communitiesChildren and Youth 

 

Right now, when try to build a visualization in desktop, I am only able to count these categories seperately. Like in this decomposition tree, I can only follow the thread of which projects are serving children and youth as first choice, then people living with mental health issues as a second choice, etc. 

Or on this dashboard, I need individual splicers for each choice to be able to filter for each choice

 

What I would like is to be able to somehow total up each category. So that regardless of which choice it is mentioned at, it would count towards a total. So like in the sample table, Children and Youth are served in 3 different projects in 3 different choices. I want the decomposition table to be able to total that up instead of spliting them by the choice selection. I imagine I will have to create a new field/column somehow in transforming the data but I have no idea how to do that. Could something be comma seperated or semicolon seperated but PowerBI would be able to recognize the individual values?

 

I tried create true/false columns for each population type but I have over 12 population types listed and couldn't find an easy way to filter on the dashboard without creating 12 different splicers. 

 

I hope my question makes sense and that someone knows of a work around that would help.