Forum Discussion
Dynamic Segment Flow DAX measure
Hey Lin,
yeah i can understand this is confusing, it's been confusing me all day!
Here is an example of what I want:
So the user is able to choose a destination week (example: last week), and a source week, lets say the week before that, using the slicers. The table will then show all combinations of segments that people had in those weeks. For example, if there were only 3 people in my data, and this is what happened:
"Johnny went from Leales to Baja Frequentia" and "Lizzy went from Novatos to En Riesgo", and "Benny also went from Novatos to En Riesgo"
The resulting data should show:
Destination Segment Source Segment Number of users
Baja Frequentia Leales 1
En Riesgo Novatos 2
That's the idea.
As you can see in the example I have come reasonable far with it. The problem is that the second column has to be a measure, and that measure currently uses a "MAX(destination segment)" which will always give Novatos.
I hope this helps a bit. Sorry for confusing you!
Jaap
hi Anonymous
If possible, please share your sample pbix file for us have a test.
Regards,
Lin
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