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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
86 | |
77 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |