See all rows in tabel visualisation

Anonymous - The sample data does not say many-to-many to me but will assume that your larger dataset does. Avoid many-to-many if at all possible. Use a bridge table. You can create one like this:

Bridge Table =
  DISTINCT(
    UNION(
      SELECTCOLUMNS('Table 1',"ID",[ID]),
      SELECTCOLUMNS('Table 2',"ID",[ID]),
    )
  )

Anonymous ,

One is the max measure on table2 when table 2 is joined with Table 1

Max(Table[value])

Another option is a new column in table 1

MaxX(filter(Table2, Table2[Id] =Table1[Id]), Table2[Value])

Anonymous - You might have an option, if you click on the drop down in the Visualizations pane of a column to "Show items with no data". That might help. Otherwise, you might do this:

Measure =
  VAR __Calc = <some calculation>
RETURN
  IF(ISBLANK(__Calc) || __Calc="",0,__Calc)

Any visualization group your duplicate data (any number of column selected) in to 1 and perform aggregation based on values. 

In your case 3 will not repeat 3 times and you will see 3 one time and value as aggregation (either SUM, AVG or No summarization)

For unmatched data you can right click field and select "show items with no data" to get missing values

If you want to view all of your data from table 1, you need to create index column and bring that index column in visualization so that group can become separate and hence all rows will be return from table 1

you can refer this article 

https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query

Hi Greg_Deckler 

My data in ID looks like this.

Thank you so much for trying to help me with this