Forum Discussion
Filter table column by measure value
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
Here you go!
| col_a | col_b | col_c |
| a | 1/1/2024 | 1 |
| a | 1/2/2024 | 2 |
| a | 1/3/2024 | 3 |
| b | 1/1/2024 | 4 |
| b | 1/2/2024 | 5 |
| b | 1/3/2024 | 6 |
| c | 1/1/2024 | 7 |
| c | 1/2/2024 | 8 |
| c | 1/3/2024 | 9 |
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
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