Help please i am trying to get the max week cost

[Dave1234]

I have 3 columns person week and cost i am trying to get the overall max week cost for each person i want to display in bar chart,

If the person does not have a overallmax week cost then still show on the bar chart but as 0

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

Table (32) has all the persons. Table (31) has test data:

Max week cost =

var _val =

CALCULATE(

SUM('Table (31)'[cost]),ALL('Table (31)'[week])) RETURN

IF(ISBLANK(_val),0,_val)


End result:
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: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/