Set Analysis

[bhavvibudagam]

Hi Experts,

Can any one please help me on this. In the below screen shot, when the Category =  Electronics and RAG Status= 'R',

I need to show corresponding Product name in the Text Object.

I have tried this expression =MaxString({<Category={'Electonics'},[RAG Status]={'R'}>}[Product Name]). But its showing only

Refregirator not showing Phone.

If  I have RAG Status = R for 3 Products I need to show 3 products names in the Text Object.

Thanks in Advance.

[tresesco]

Use concat() instead of maxstring() like:

Concat(Distinct {<Category={'Electonics'},[RAG Status]={'R'}>}[Product Name] , ',' )

[madhumitha]

Hi Bhavani,

Please find attached workaround.

Hope this helps.

Thanks!