Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |