Create Relationship within Measure

[joshua1990]

Hello everyone!

I need to create a relationship between two tables within a dax measure.

I have the following both tables:

tblOrder

OrderNr	Date	Value
1	01.01.2020	5000

tblLedger

OrderNr	Date	Type	Quantity
1	01.01.2020	B	50
1	01.01.2020	T	500

Unfortuantely, for now it is not possible to link both tables in the data model.

So there is wheter an active oder inactive relationship.

Now I would like to display every order in a matrix/ table with two colums.

The first one for all Types = B

And the second one for all Types = T

But how?

[Anonymous]

Hm... I might be able to help you if I could understand what you've written here... But I can't. Sorry.

[amitchandak]

@joshua1990 , Not very clear, You can take type on matrix column. Ideally, these two should be joined to common orderNr Dimension