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

    Get Multiple Value from Multiple Unique value.pbix40 KB
StrategicSavvy's avatar
StrategicSavvy
Resolver II
2 years ago

hi Wicak , 

 

To get this you need to create new table and use UNION formula.

 

here is the code :

Table A = 
    UNION(
    'Table B',
    'Table C',
    'Table D'
)

 

This code will return multiple values from 3 tables

 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: www.linkedin.com/in/lukasz-kozdron 

  • Wicak's avatar
    Wicak
    Helper I
    2 years ago

    hi StrategicSavvy 

    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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      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

      Get Multiple Value from Multiple Unique value.pbix40 KB