Forum Discussion
thaynanff
1 year agoNew Member
Filter Context Not Flowing Through Bridge Table in Power BI Model
Hi everyone, I’m working on a financial analysis model, and I’ve run into a relationship/filter propagation issue that I can’t resolve. I’ll explain the setup and the symptoms clearly below. ...
- 1 year ago
Hi thaynanff ,
Your dax code is working fine. The issue is that in the Pillar column of the DIM_SectoralPillars you always have a whitespace before the text. This is causing the issue when you try to filter on pillar in your measure. In PowerQuery you can trim the column to remove the whitespace.
Demert
Resolver III
1 year agoHi thaynanff ,
Your dax code is working fine. The issue is that in the Pillar column of the DIM_SectoralPillars you always have a whitespace before the text. This is causing the issue when you try to filter on pillar in your measure. In PowerQuery you can trim the column to remove the whitespace.