Forum Discussion

garycarters's avatar
garycarters
Icon for Helper I rankHelper I
6 years ago
Solved

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

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...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    6 years ago

    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