Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Compute a daily average into a calculated column

Hello Everyone,   I'm having a bad time trying to solve this situation.   For some reason, I need to compute a measure into a calculated column. To sum up, I have many different measures computed...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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