Forum Discussion
issue using same column in two tables
Hi eniX,
In your scenario, we can concatenate corresponding part to one row, but we aren't able to display corresponding part to separate rows from the same query.
You can create a measure like this:
Measure = var temp=CALCULATETABLE(VALUES(Table1[car]),ALLSELECTED(Table1[part]))
return
CONCATENATEX(CALCULATETABLE(VALUES(Table1[part]),FILTER(ALL(Table1),CONTAINS(temp,[car],[car]))),[part],",")Best Regards,
Qiuyun Yu
Hi eniX,
In your scenario, we can concatenate corresponding part to one row, but we aren't able to display corresponding part to separate rows from the same query.
You can create a measure like this:
Measure = var temp=CALCULATETABLE(VALUES(Table1[car]),ALLSELECTED(Table1[part]))
return
CONCATENATEX(CALCULATETABLE(VALUES(Table1[part]),FILTER(ALL(Table1),CONTAINS(temp,[car],[car]))),[part],",")
Best Regards,
Qiuyun Yu
I definitely need them in a seperate row, because I want to display additional information. Thanks for pointing out, that it's not possible with Power View.
v-qiuyu-msft, can you tell me then what is my best option to model it? Calculated table/cross product/copying the table/other possibility? I really need to keep my data model at minimal size due to 1GB limit :/
Hi eniX,
You can filter to keep useful data in Query Editor, apply useful data to data model. Or you can try the DirectQuery if possible.
Best Regards,
Qiuyun Yu