Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

SumIf into powerBi..

Hi,   I am trying to get an equivalent of SUMIF on Power BI, however I am having problems. I have tried the function calculator but to no avail. I want to create a formula that sums a column on a ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous,

    Current power bi does not support create dynamic calculated column/table based on filter effect. They were not host on the same level and you can't use the child level to effect its parents.

    Notice: the data level of power bi(from parent to child level)

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng