Measure Filter in Direct Query

[Seek08]

Hi,

I am working with Direct Query and there is a measure in table visual and that same measure is used as visual level filter in table visual. I know there is a limitation in direct query to use measure as filter.

Measure = CALCULATE([KPI1]*[KPI2])

and same measure is being used as visual level filter to display values where Measure is less than 0.6 This is working but the visual is very slow. When I changed the measure to

Measure = var _a=CALCULATE([KPI1]*[KPI2])
return IF(_a<0.6,_a,0), this becomes fast but then I am not getting total.

[Seek08]

First of all my dim column is coming from field parameter, but for testing I removed it and picked directly column from a dim table and wrote this measure

Test = var _a =CALCULATE([KPI1]*[KPI2])

return if(_a<0.6,SUMX(VALUES('Dim'[name]),_a),BLANK())

But this kept on spinning for minutes

[amitchandak]

@Seek08 , This need to executed at line level or level based on common dim

Sumx(Table, [KPI1]*[KPI2])

or

SumX(Values(Dim[Category]), [KPI1]*[KPI2])