SUM and MAX of sales based on flag

[Ainala]

Hello Power Users,
I'm trying to create a dax measure for below table structure. If the Flag = Y then take max of sales  and if flag = "N" then sum of sales for all the months.

Year	Month	Customer	Sales	Flag
2022	1	ABC	100	N
2022	2	ABC	55	N
2022	3	ABC	110	N
2022	1	XYZ	110	Y
2022	2	XYZ	110	Y
2022	3	XYZ	110	Y

I have Year and Customer slicers on the page. 

How can we achive this.  Please help.

Thanks

[v-easonf-msft]

Hi, @Ainala 

Please try measure as below:

Measure = SWITCH(MAX('Table'[Flag]),"N",SUM('Table'[Sales]),"Y",MAX('Table'[Sales]))

If it does't work, please provide more details for further investigation.

Best Regards,
Community Support Team _ Eason

[negi007 · Accepted solution]

@Ainala 

create below measure

Max_sales = CALCULATE(MAX(Tab[Sales]),Tab[Flag]="Y")

Sum_sales = CALCULATE(SUM(Tab[Sales]),Tab[Flag]="N")

then create a calculated column 

Sales_New = if(Tab[Flag]="Y",[Max_sales],[Sum_sales])

let me know if this is what you want.