Multiselections Filteringand Grouping?

[GrayZatt]

Hey all, im trying to create an equipment report but im having issues with the results.

Usecase:

Name	type	value
ED1	version	V1.2
ED1	co	UK
ED2	version	V1.2
ED2	co	NO

Filter in two dropdowns on co=UK and version=V1.2

Normal result will be:

Name	type	value
ED1	version	V1.2
ED1	co	UK
ED2	version	V1.2

Is it possible to exclude data where both filters are not present and group the remaining like below to get single line for each "Name"?

Name	type	value
ED1	Version/co	V1.2/UK

[v-frfei-msft · Accepted solution]

Hi @GrayZatt ,

One sample for your reference.

Here we need create a calculated table firstly.

filter = VALUES(Table1[value])

Then we can create two measures as below to get the excepted result.

Type1 = var con1 = CONCATENATEX(Table1,Table1[value])
var con2 = CONCATENATEX('filter','filter'[value])
return
CONCATENATEX(FILTER(Table1,con1=con2),Table1[type],"/")

value1 = var con1 = CONCATENATEX(Table1,Table1[value])
var con2 = CONCATENATEX('filter','filter'[value])
return
CONCATENATEX(FILTER(Table1,con1=con2),Table1[value],"/")

Pbix as attached.

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @GrayZatt ,

One sample for your reference.

Here we need create a calculated table firstly.

filter = VALUES(Table1[value])

Then we can create two measures as below to get the excepted result.

Type1 = var con1 = CONCATENATEX(Table1,Table1[value])
var con2 = CONCATENATEX('filter','filter'[value])
return
CONCATENATEX(FILTER(Table1,con1=con2),Table1[type],"/")

value1 = var con1 = CONCATENATEX(Table1,Table1[value])
var con2 = CONCATENATEX('filter','filter'[value])
return
CONCATENATEX(FILTER(Table1,con1=con2),Table1[value],"/")

Pbix as attached.

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @GrayZatt ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[GrayZatt]

Yes perfect! 🙂

Thanks for your time