Forum Discussion
Solved
Data modeling - Non unique values
Hello all! First I'd like to thank all who read this and intend to help, you make this comunnity awesome! I'm trying to link 2 tables, a FACT and a DIMENSIONS one, but this latter doesn't ...
Hi, using a calculated column And DimA is 10
When DimA-10 = LOOKUPVALUE ( Table1[Dim B], Table1[Ticket], Tickets[Ticket]; Table1[Dim A], 10 )Using a measure:
Measure-When DimA-10 = IF ( HASONEVALUE ( Table1[Ticket] ), LOOKUPVALUE ( Table1[Dim B], Table1[Ticket], VALUES ( Tickets[Ticket] ), Table1[Dim A], 10 ) )let me know if works.
Victor
Tulio_DL,
Create the calculated column in TABLE A.When DimA-10 = LOOKUPVALUE ( 'TABLE B'[DIM b], 'TABLE B'[Ticket], 'TABLE A'[Ticket], 'TABLE B'[DIM a], 10 )
Also you can change the second formula of Vvelarde to the following:Measure-When DimA-10 = IF ( HASONEVALUE ( 'TABLE B'[Ticket] ), LOOKUPVALUE ( 'TABLE B'[DIM b], 'TABLE B'[Ticket], VALUES ( 'TABLE A'[Ticket] ), 'TABLE B'[DIM a], 10 ) )
Regards,
Tulio_DL,
Create the calculated column in TABLE A.
When DimA-10 =
LOOKUPVALUE (
'TABLE B'[DIM b],
'TABLE B'[Ticket], 'TABLE A'[Ticket],
'TABLE B'[DIM a], 10
)
Also you can change the second formula of Vvelarde to the following:
Measure-When DimA-10 =
IF (
HASONEVALUE ( 'TABLE B'[Ticket] ),
LOOKUPVALUE (
'TABLE B'[DIM b],
'TABLE B'[Ticket], VALUES ( 'TABLE A'[Ticket] ),
'TABLE B'[DIM a], 10
)
)
Regards,
