Forum Discussion
Solved
Get Multiple Value from Multiple Unique value
how to get multiple values from 3 tables based on unique values? Result = VAR A = Calculate( MAX('Table B'[Size]), Filter('Table B','Table B...
Hi Wicak ,
You can make a little adjustment on the formula which provided by StrategicSavvy , please note that what he is creating is a calculated table.
Table A = UNION ( SUMMARIZE ( 'Table B', 'Table B'[Unique Number], 'Table B'[Size] ), SUMMARIZE ( 'Table C', 'Table C'[Unique Number], 'Table C'[Size] ), SUMMARIZE ( 'Table D', 'Table D'[Unique Number], 'Table D'[Size] ) )Best Regards
thank you for your reply. so sory table B, C and D is dumy, actually their table have multiple column. i try in DAX PBI and DAX has a get error pop up
is there any way other to solve this problem?
Hi Wicak ,
You can make a little adjustment on the formula which provided by StrategicSavvy , please note that what he is creating is a calculated table.
Table A =
UNION (
SUMMARIZE ( 'Table B', 'Table B'[Unique Number], 'Table B'[Size] ),
SUMMARIZE ( 'Table C', 'Table C'[Unique Number], 'Table C'[Size] ),
SUMMARIZE ( 'Table D', 'Table D'[Unique Number], 'Table D'[Size] )
)
Best Regards