Forum Discussion

gambleave's avatar
gambleave
Icon for Helper II rankHelper 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

  • gambleave's avatar
    gambleave
    Icon for Helper II rankHelper II
    4 years ago

    Thanks very much for your help. My plan is to link the table to an existing data model and have this information display along with other existing measures (when a particular consultant is selected by filter). So far no luck getting this to work properly since it's a many relationship (tried setting both directions to the relationship and using crossfilter). Is there a way to get this working working, except by deleting rows from the source table?