Forum Discussion
How to slice data for several columns
- 1 year ago
Anonymous
do not create relationship between two tables.
create a measure
Measure = if(max('Table'[Manager])=max(Manager[Managers])||max(Manager[Managers])=max('Table'[Project Owner Name]),1)and add this measure to visual filter and set to 1pls see the attachment below
Thanks for your help. Would this be possible if Project Owners are a measure that concatenates several different project owners if they have the same project ID? I have a separate measure for that, so was wondering if I could do something like "if contains" or something of that sort.
do you mean multiple seleciton or something else? could you pls update the sample data and expected output?
- v-aatheeque1 year agoCommunity Support
Hi Anonymous
I wanted to follow up on your question regarding the possibility of using a measure to concatenate multiple project owners based on the same project ID.To assist you more effectively, could you please provide the sample data and the expected output? This will help us understand your requirements better and offer a more targeted solution.
Thank you for your cooperation, and I look forward to your response!
- v-aatheeque1 year agoCommunity Support
Hi Anonymous
Just following up on my earlier request for some sample data and the expected output regarding your question about using a measure to concatenate multiple project owners by project ID.
Sharing this information will really help us better understand your scenario and suggest the most suitable solution.
Looking forward to your response.
thank you for your cooperation!