filtering over distinct values in a table

[CL7777]

I have a table called "jobs" that looks something like this

job number     operation      total job price      cost

1                        cut              100                         36

1                        mill              100                        36

1                        shop            100                        36

2                        lathe             50                         18

2                        shop             50                         18

I want to create measures that have total price  and total cost as a function of distinct job numbers. so, for example, if I create a table in a visual and pull in job number and these measures, I want to see

job number    total job price      cost

1                      100                       36

2                       50                        18

I DONT want to see:

job number    total job price      cost

1                      300                      108

2                      100                        36

So, its like I want a measure that calculates the average (or the max) over each job number and adds that up for distinct job numbers, not for distinct lines in the original table.

Any help would be much appreciated

[DataInsights · Accepted solution]

@CL7777,

You could use MIN or MAX since the numbers are same for each line of a job number.

Measures:

Job Price = MAX ( jobs[total job price] )

Job Cost = MAX ( jobs[cost] )