Why a DAX measure that returns multiple values can not be shown in a visual table?

[Anonymous]

Hi guys!

First of all thanks for all the help ^^ it really helps us learning how to better use the tool and create new projects!

Second, I encountered an "issue" when I tried to show some values from a DAX measure with a visual (a table).

As you can see in the image, our goal is to have a list of all "Part Number" values to that when selecting one or more products from the slicer, it shows us only the Parts that are just related to this products AND...  NOT related to any other product.

Such like if I have "Product 1" selected and this has "Part 1", "Part 2" and "Part 3" related, but... "Part 2" is also related to "Product 4" ... on the table it should just appear "Part 1" and "Part 3" (And not show "Part 2")

I've created a measure for this behavior But I'm not sure I've did it as I should. Because as you can see in the image, there's the slicer on the left, some counters to calculate disctinct values when selecting and 2 tables. The table at the bottom have the measure that I consider it should work and it does NOT. I've only could make it show the values using a CONCATENATEX to see them and check. But it's not useful like this right now.

My doubt here is: 

If I create a measure that returns me multiple values and I want them to be on a table (that can show multiple values) why is this table expecting a single value?

In my head it should create a column with all values inside that I would later use to relate with the descriptions and more info that is in the "Part Number Table"

Maybe I should put this values into a column? but I've tried and I wasn't succesful.

I'm a bit lost and your knoledge here it would be a great help.

So if you have some time to take a look I'll really appreciated.

Thanks ^^

https://drive.google.com/file/d/1myxBVZUa0MzUzitUFyEiaAFWOMIHIEl_/view?usp=drive_link

[PhilipTreacy]

Hi @Anonymous 

Create a new table from the Modelling section of the Ribbon.  Use the DAX code you've already written to create this table (return the column of values).

You can then create a relationship with it and display it in a table.

Phil

[PhilipTreacy]

Hi @Anonymous 

A measure is complicate and can be confusing. If you create a measure that returns multipel values, that measure can't be displayed niside a single cell of a table.

A measure in such a case must return a single value.  So for each cell in the table, the measure is calculating a value and it must be only a single value, so that the cell only contains asingle value.

If you create a measure that returns a table, you can't display a table in a cell of a table visual.  In such a case you can create a new table (from the Modelling section of the Ribbon) and use the DAX for your measure to create this table.  That can then be displayed in a table visual.

Regards

Phil

[Anonymous]

@PhilipTreacy 

Thanks for the time man ^^, but it's the other way arround actually.
I do not know how to get this multiple values into a column.

I was just commenting that in orther to see which values I was getting I've concatenated them into a single string of text. But that is not useful for the purpose we need to solve.

Would you know how to actually see this multiple values into a table so that they could also be related to other tables?

Sorry if I misslead with the explanation.

Thanks 🙂