Calculate filter dosnt work on summarize table

[Anonymous]

Hi, I hope someone can help me with this one. I wanna make a measure over table A, applying a filter over table C. Table A is connected with table B and B with C.

The measure is:

msr = CALCULATE(AVERAGE('A'[S]);'C'[flag]=1) 

The table A comes from a summarize of table B.

A = SUMMARIZE('B'

;'B'[col1]

;"S";sum('B'[col2])

)

I have all tables linked with cross filters option set as both.

The problems is with the filter in the Calculate, it doenst work. The measure is just the average but without filtering any data. The behavior I'm expecting is the "summarize table" recalculate with the filter applied in the Calculate.

Thanks!

[Greg_Deckler]

Perhaps using RELATED or RELATEDTABLE? Would need sample data to test. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490