Help! Mental block on how to calculate/visualize my data

[MatH]

Hello,

Thanks in advance. I have a table that has reasons for why people have contacted our helpline. 

The table includes a 'Lead ID' that is unique to individuals, and then a reason category, sub category and value (True/false)

I can currently display this as a list of reasons and a count of true for each one to see how often they're recorded, and filter by it.

But people can have more than one. I want to be able to say if for Lead IDs that have value X what other values do they have?

I'm having a mental block on how to get this visualisation, as when I filter by subcategory it only shows me that one. I tried some other measures to filter by Lead ID on the subcategory but also didn't have much success.

I really appreciate any help overcoming this.

[Greg_Deckler]

@MatH Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[MatH]

Hi @Greg_Deckler ,

My table would look like this just using random topics but the point remains:

Lead ID	Reason Category	Reason Subcategory	True/False
1	Sauce	Ketchup	True
1	Seasoning	Salt	True
2	Sauce	Ketchup	True
3	Seasoning	Salt	True
4	Sauce	May	True

As you see 'Lead IDs' or people could have more than one row, as they may have more than one category/subcategory. I want to filter to say filter by those who had subcategory Ketchup in this example and see oh they also had salt. If that makes sense?

At the moment I'm just able to filter to see the total amount of any individual subcategory. I want to see where they go together, so where people have X subcategory they're likely to have Y as well.

[Greg_Deckler · Accepted solution]

@MatH Try:

Measure = 
  VAR __LeadID = MAX( 'Table'[Lead ID] )
  VAR __Table = FILTER( ALL('Table'), [Lead ID] = __LeadID )
  VAR __Result = CONCATENATEX( __Table, [Reason Subcategory], ", " )
RETURN
  __Result