Totals not adding up for measure which is based on dynamic filtering

[sudhakar111]

 Hello All,

 I am building a report which has measure column whos values changes based on filter selection. The attached screenshot has a column 2022 planned Mtd. The values of this column have to change based on each individual filter selection. 2022 planned Mtd is a combination of measures for each brand. Below are the formulas. The values change for each selection. But the total does not change.

2022_Planned_Mtd = if (max(Brands[Brand])="Brand1",Table[Planned_Mtd_Brand1],if(max(Brands[Brand])="Brand2",Table[Planned_Mtd_Brand2],
if(max(Brands[Brand])="Brand3",Table[Planned_Mtd_Brand3],if(max(Brands[Brand])="Brand4",Table[Planned_Mtd_Brand4])))))) 

Planned_Mtd_Brand1 =

VAR selected =

SELECTEDVALUE ( Sheet1[Value])/100 RETURN

SUM ( 'SALES'[PY_MTD] )+SUM ( 'SALES'[PY_MTD] ) * selected

[sudhakar111]

@v-yanjiang-msft   Please find the link to the sample PBIX file. The planned MTD column total does not change based on the filter selection.

https://drive.google.com/file/d/1xIplQZW3jHeNypqJy4B_NIEuzCemHL9w/view?usp=sharing

[v-yanjiang-msft]

Hi @sudhakar111 ,

Need more information to analyze the internal logic of the problem, could you please provide a sample file without sensitive information?

Best Regards,
Community Support Team _ kalyj