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

dzamrazil's avatar
dzamrazil
Regular Visitor
3 years ago

Hi,

maybe somebody will help you this little thing that helped me out.

This dont work for me, until i didnot change the Measure

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

 My Measure was using = Values() to take actual filtered option from slicer.
But its single take, so when i change it, and use MAX(), which always return only one string, everything start works.

So take a look on your VAR m = Measures