Forum Discussion
Compute a daily average into a calculated column
Hi Anonymous,
AFAIK, current power bi not able to create a dynamic calculate column/table based on filter/slicer. They are stored in different data levels and not able to interact from slicer/filter.
I'd like to suggest creating a measure formula to instead, its result can dynamic changes based on filtered row contents.
Notice: data levels (from parent to child, child level not able to affect the higher level)
database -> query table -> data model table(calculate column/table) -> data view(measure, fitler,slcier, visauls)
Regards,
Xiaoxin Sheng
Hi Anonymous,
AFAIK, current power bi not able to create a dynamic calculate column/table based on filter/slicer. They are stored in different data levels and not able to interact from slicer/filter.
I'd like to suggest creating a measure formula to instead, its result can dynamic changes based on filtered row contents.
Notice: data levels (from parent to child, child level not able to affect the higher level)
database -> query table -> data model table(calculate column/table) -> data view(measure, fitler,slcier, visauls)
Regards,
Xiaoxin Sheng
Thank you!
I understand what is possible and what is not now; the hierarchy level is clear.
This is not a solution but it helps! I found another way, involving measures indeed to make appear what I was looking for; created the measures, and then created a table of measures (with formulas UNION and ROWS). With only the measures, I couldn't reach my goal.