Filter Condition working

[krishnagutha1294]

Hi All

I am Having A table like below

If i select any filter the valves are changing like below

Please any one can help me how to resolve it.

Thank You In advance

Krishna.G

[arulsettu]

So the table should not change even if any filter selected?

[krishnagutha1294]

If you select any filter The valve of that filter won't change.

[Kushal_Chawda]

What is the expression you are using?

[krishnagutha1294]

Using the following Expression

Round((Count({<"Commodity Group"={'HDD - Hard Disk Drive','SSD - Solid State Drive','Power Supply'}>} actn_part_srl_nr2)/count(total<[Commodity Group]>BU))*1000000)

+ Round((Count({<"Commodity Group"={'Processor'}>}[ncnfrmc_cd1])/Count(total<[Commodity Group]>BU))*1000000)
+ Round((Count({<"Commodity Group"={'Memory'}>}[ncnfrmc_cd2])/

if(
[Commodity Group]='Memory',
Count({<[Commodity Group]={'Memory'},[Standard Supplier]={'Samsung','SK Hynix','Micron','Kingston'}>}BU),
Count(total<[Commodity Group]>BU))*1000000)
)

[Kushal_Chawda]

looks like the If condition is the problem here. It will change it based on the selections

can you try below

if(
only({1}[Commodity Group])='Memory',
Count({<[Commodity Group]={'Memory'},[Standard Supplier]={'Samsung','SK Hynix','Micron','Kingston'}>}BU),
Count(total<[Commodity Group]>BU))*1000000)
)

[Kushal_Chawda]

or try wrapping up the if statement or entire expression  with aggr like below

sum(aggr(if(
[Commodity Group]='Memory',
Count({<[Commodity Group]={'Memory'},[Standard Supplier]={'Samsung','SK Hynix','Micron','Kingston'}>}BU),
Count(total<[Commodity Group]>BU))*1000000)
), Osv_category,Month))

[krishnagutha1294]

Sorry its not working

[krishnagutha1294]

This one also not working 

Thanks for response 

[arulsettu]

Provide sample app