Forum Discussion

sthokchom's avatar
sthokchom
Frequent Visitor
2 years ago

Help needed to DAX logic

Hi Community, Could you please help me solving the below use case. I have calender table consists of year and month. I have both year and month values as a 2 different slicer on report. Now I want ...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sthokchom,

Current power bi does not support to create dynamic calculated column/table based on filter effects. They weren't hosted on the same level and you can't use the child level to effect the parent level.

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

sthokchom's avatar
sthokchom
Frequent Visitor
2 years ago

Hi 123abc ,

Thanks for your valuavle input. But none of those are working. When I select 2024 in Slicer 1, nothing happnes in slicer 2. All the months still get displayed.