how to group multiple filters under same application ID

[bbotros77]

Hello, 

I have unique application IDs , where under each application ID multiple Roles may exist (Eng , Accountant , ..etc) with a Full Name for each role.

When try getting those into a report , I got the same application ID repeated to refer to each Role , so the same application ID may show for examples Four times in the report because there were Four Roles handling such application.

I am looking for a way to have the application ID show up just once in the report , with the mulitple Roles show up all at once horizontally.

appreciate your help.

[Anonymous]

Hi @bbotros77 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[danextian]

Hi @bbotros77,

Please post a sample data and your expected result so we can have a better picture of what you're trying to achieve. Data must be workable (eg a link to an Excel file in the cloud) and not an image.