Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
9 years ago
Solved

Filter with calculated measures

hi, i know that calculated measures is changing regard it's context. i'm using a 'Text' type calculated measure to filter another calculated measure. since it's value is not stable, filter with ca...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    MP_123

    how can i filter with dynamically filter?

    Have you tried the VAR function that I mentioned in your previous thread? In this scenario, the formula should like below.

    = 
    VAR m = Measures
    RETURN
    CALCULATE ( SUM ( 'x' ), FILTER ( 'y', column = m ) )

    If the result is still not right, could you post your table structure and the measures you use, and some sample data in your case?:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

MP_123

how can i filter with dynamically filter?

Have you tried the VAR function that I mentioned in your previous thread? In this scenario, the formula should like below.

= 
VAR m = Measures
RETURN
CALCULATE ( SUM ( 'x' ), FILTER ( 'y', column = m ) )

If the result is still not right, could you post your table structure and the measures you use, and some sample data in your case?:smileyhappy:

 

Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Can somone tell me why this works

= 
VAR m = Measures
RETURN
CALCULATE ( SUM ( 'x' ), FILTER ( 'y', column = m ) )

and this does not:

CALCULATE ( SUM ( table1[x] ), FILTER ( table1, table1[y] = measure ) )

I had a sample excel where it worked fine in but i had to implement your VAR method for my SSAS and powerpivot model....