Forum Discussion
Helper IVUCL/LCL with filter
HI alevandenes,
AFAIK, current power bi does not support create dynamic calculated column/table based on filter effects, they do not work on the same level and you can't use the child to affect its parent.
For this scenario, you may need to add 'problem type' as category to the summarize table with different results based on the 'problem type' group. Then you use filter on the result table based on problem type.
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
alevandenesHi, thanks i understand. Is there maybe another way I can obtain this that it is not creating a table? this is the solution i found, but i am actually okay with changing everything completely if i can obtain what i need.HI alevandenes,
Perhaps you can try to create the basic summary table with all value result, then you can create measure expression to extract the total value and calculate with the percent of filter selection and total items.
Regards,
Xiaoxin Sheng