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?


For example, if meas_a = "c", then only the last three rows will be included in the visualisation.

Here's a non-picture version of the above table:

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



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

5 Replies