Forum Discussion

costing's avatar
costing
Frequent Visitor
2 years ago
Solved

Filter table column by measure value

I have a table my_table  below and a measure meas_a which takes on values a, b or c How can my time series visualisation using col_b (x-axis) and col_c (y-axis) be filtered by col_a = meas_a? ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI costing,

    Measure expressions are calculated based on their row contents and group. If you want to invoke the specific calculation results in other measure formulas.
    It should be better to create variable with summarize function to reproduce the current row contents structures and you can invoke the measure in this variable table.

    Reference link:

    Measure Totals, The Final Word 

    Regards,

    Xiaoxin Sheng

costing's avatar
costing
Frequent Visitor
2 years ago

Hi, sorry I have no idea how the link relates to my question 😅

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi costing 

    Please share sample data in usable format (not an image)

    • costing's avatar
      costing
      Frequent Visitor
      2 years ago

      Here you go!

      col_acol_bcol_c
      a1/1/20241
      a1/2/20242
      a1/3/20243
      b1/1/20244
      b1/2/20245
      b1/3/20246
      c1/1/20247
      c1/2/20248
      c1/3/20249


      my attempts have been to create new measures for col_b and col_c
      For example for col_c

        not_working_meas_c = calculate(my_table[col_c], my_table[col_a] = [meas_a])

      However this is incorrect DAX. 

      The below does work, but it gives the sum, a single value, whereas I need a value for each row from the filtered table to go into the time series chart:

        unhelpful_meas_c = calculate(sum(my_table[col_c]), my_table[col_a] = [meas_a])

      It seems like a very simple use case.  If you know R, the answer would simply be:


        r_meas_c = my_table[col_a == meas_a]$col_c

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        HI costing,

        Measure expressions are calculated based on their row contents and group. If you want to invoke the specific calculation results in other measure formulas.
        It should be better to create variable with summarize function to reproduce the current row contents structures and you can invoke the measure in this variable table.

        Reference link:

        Measure Totals, The Final Word 

        Regards,

        Xiaoxin Sheng