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 |
---|---|
104 | |
86 | |
80 | |
73 | |
72 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |