Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi. I'm trying to create a table that uses several editable daily rates for several job positions in order to compute total costs. The Positions are different job classes, the levels within positions are the same from a structural point of view, but the rates for the positions vary between the Positions.
I've created fixed decimal parameters for each specific rate, and then tried to use them in an expression like this:
Solved! Go to Solution.
Hi @dbk58 ,
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 @dbk58 ,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |