Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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
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
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
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
Yes perfect! 🙂
Thanks for your time
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |