Forum Discussion

Wicak's avatar
Wicak
Helper I
2 years ago
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...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Wicak's avatar
Wicak
Helper I
2 years ago

hi Anonymous 

thanks for advice, at the end i do your methode combine with relationship 😁