Is it possible to use a measure to display values in a table?

[jimmyswoosh]

Hi Power BI Community,

I have multiple tables, for simplification, let's say I have two tables in the following format.

I also made a table with two values which is being used in a slicer:

Conversations Created, Conversations Root Comment

I want to use a table as a visual, with measure as a value.

Logic would be if I select "Conversations Created", the table should show values from the conversations created table and vice-versa for the other selection.

Does anyone know if this is possible?

Thanks!

[Anonymous]

In the relationship module connect the relevant tables with the relevant columns.

It should work out of the box, as you described.

Ta

[jimmyswoosh]

Thanks for the reply @Anonymous ,

I do have my relations setup. Apologies, I wasn't clear on what my issue is.

I have my main dataset, that has data on users, such as timestamp, comment message, comment type, state.

Comment Type could be the following:

• Article Child Comment
• Article Root Comment
• Conversation Child Comment
• Conversation Root Comment
• Created Conversation
• Video Child Comment
• Video Root Comment

Different states it can be in:

• Approved
• Deleted
• Pending
• Rejected

What I want is to be able to see what the comment distribution is for each comment type. Meaning a summarized view, like a matrix table where the row is the max comments made by a user, and the column would be # of users who made that many comments. A slicer on the comment type would change what this table is filtered to. I couldn't achieve this from just using the main dataset so I decided to summarize the main table into sub tables for each comment type to have the desired output. Now I want to create a measure to return the selected table contents based on the slicer selection.

Example below:

*Note, this is sample data. I only provided 1 type of comment type ('conversations created') and 2 states ('approved', 'pending')

The orange table is the desired output. I have created summarized tables in that view for each comment type. Now I want a measure to return that table so I can visualize it in a table view. I'm just not sure how to write the DAX for it.

-Thanks

[jimmyswoosh · Accepted solution]

Decided to create summarize subset tables and put them in matrix table visual on a page.