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

MP_123's avatar
MP_123
Microsoft Employee
9 years ago

v-ljerr-msftthanks! your awsome!

  • amalhotr's avatar
    amalhotr
    New Member
    8 years ago

    VAR m = [Measure]
    RETURN
    CALCULATETABLE('Table 2','Table 2'[QUARTER]=m) Not working with calculatedtable DAX function

    • Michiel's avatar
      Michiel
      Resolver III
      8 years ago

      What is the error that you get? You cannot use this directly in a measure, but that is because a measure must return a scalar value, not a table (which is wat CALCULATEDTABLE returns). So at least it should be wrapped in a table aggregation function.