Forum Discussion
Nested Parameters in DAX expression in Table Visual
- Anonymous6 years ago
Hi Anonymous ,
Current power bi not support to create dynamic calculated table/column based on filter/slicer.
Measure is a expression for calculate, it works on data view level(visual, filter, measure, slicer) which generated from data model tables and it will been affected by its row contents filter.
They are stored in different data levels and you can't use child level(data view) to affect its parent level(data model: table, column, calculated column/table).
Regards,
Xiaoxin Sheng
Hi Anonymous ,
Current power bi not support to create dynamic calculated table/column based on filter/slicer.
Measure is a expression for calculate, it works on data view level(visual, filter, measure, slicer) which generated from data model tables and it will been affected by its row contents filter.
They are stored in different data levels and you can't use child level(data view) to affect its parent level(data model: table, column, calculated column/table).
Regards,
Xiaoxin Sheng
Well that's unfortunate. Essentially these are just constants that get adjusted once per year.
Oh well - we'll have to look at generating a table with these rates for each position.
Thanks.