Forum Discussion

gambleave's avatar
gambleave
Helper II
4 years ago

Linking a table with mixed data fields

May I please have advice on how to incorporate a table such as the one below into a typical data model? Can it be achieved with measures only, or does the table itself need to be modifed?   The tab...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  gambleave ,

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
    MAX('Table'[Introduction Needed?])="Yes",MAX('Table'[Account Manager]),BLANK())

2. Select Matrix visual.

3. Turn on Format - Row headers - Stepped layout to OFF.

4. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly