Card visual needs to show header value rather than summed by lines

[garycarters]

I'm trying to do something that is probably quite simple but I can't get my head round.

I have a Card visual that shows the total cost for a data set, linked to a filter over Work Number.

The table behind the visual is a detail transaction listing codes allocated to each work number along with a cost (screenshot of example records attached) - there can be multiple records per worknumber. 

The actual cost is held per worknumber on a the header table and included in the detail as Column analysisActualPartsCost = RELATED(worksorderhdr[actual_parts_cost]) .

The problem I have is when i apply the filter the value of all the lines are summed, whereas in my example, when filtering by WO-020964 the visual should show a cost of 64.8, but instead it shows 3 x 64.8 (as there are 3 records).

[v-piga-msft]

Hi @garycarters ,

Have you solved the problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, free to ask.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @garycarters ,

I'm a little confused about your scenario.

If I understans your total cost correctly that it is a measure like below.

total cost = CALCULATE(SUM('Table'[Cost]))

If so, I think the card behaviour is correct.

If you only want to show the 64.8 when the selectedvalue is WO-020964, you could use the measure like this.

total cost = CALCULATE(MAX('Table'[Cost]))

In addition, there are four records for 64.8 in your image.

If you still need help, free to ask and please share your data sample as table format so that we could have a test on it.

Best  Regards,

Cherry

[garycarters]