Forum Discussion
Dynamic Segment Flow DAX measure
Hey all, I've been struggling a lot today, trying to get something to work. What I'm trying to build is a dynamic segment migration report. For every week, every customer is put into one of 5 se...
hi Anonymous
First, you should know that:
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary resuly based on current row context.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Since _Segmentname Source is a measure, I think it is difficult to achieve in power bi.
Regards,
Lin
Yes I think what I wanted was not possible in PowerBI. I used another "solution" that just takes the value from 4 weeks ago, from 8 weeks ago and from 16 weeks ago in columns.
Thanks for thinking along!
Jaap