Need help with Summarize function

[Anonymous]

Hello,

I have two tables like TBL and CUST. I have created the CUST table using the DAX.

CUST=

ADDCOLUMNS(

SUMMARIZE(FILTER(TBL,NOT(TBL[Account])=BLANK()),TBL[Account ],

"Sale",CALCULATE(SUM(TBL[Sale Amount]),FILTER(TBL,TBL[Ind]="Yes"),FILTER(TBL,TBL[Ind2]="Yes" && NOT(TBL[Code]) IN {"4"} ))

),

"Grp",

IF ( [Premium] >=0 && [Premium]<100, "0-100",IF ( [Premium] >=100&& [Premium]<500, "100-500",IF ( [Premium] >=500 && [Premium]<1000, "500-1000M",IF ( [Premium] >=1000, "1000+" )))))

Now, I have created a relationship between those two tables using "Account" column and created a Cust Grp column in TBL using Related(CUST[Grp]). I want build a customer count based on grouping. 

Problem:

Counts were fine when there were no filters applied but when I apply a filter on TBL tables Sale amount in CUST table is not filtering(I selected filtering as Both direction). As a result, counts in the group are not being calculated properly. 

For example, if I filter country in TBL to the "USA" the premium in the CUST table is not changing.

Please help me out!!!!

Thanks in advance!!!!!

[v-piga-msft]

Hi @Anonymous ,

More details will be helpful.

If it is convenient, could you share your data sample which could reproduce your scenario and your desired output so that we could help further on it?

Please refer to how to get your question answered quickly.

Best Regards,

Cherry