Forum Discussion
Dynamic Z Score Calculation
Hi all, need some help. Have problem with calculation dynamic Z Score in one of my power bi reports. I created 'Dynamic Measure' table where I inserted all measures names. After that I c...
Yes, yes I set all properties correctly and all works fine with separate measures for separate dimensions (Sport, Events, Competitions).
But, when I try to calculate dynamicly 'ALLSELECTED' part where I want to dynamicly set dimension ( ALLSELECTED(Sports), ALLSELECTED(Events) ....), for some reason I can't.
Do you know how to achieve that? Thanks!
Hello,
Can you please attach a sample dataset? or screenshots of your table structures, and front-end report visuals and slicer.
It will be more clear. I believe selectedvalue() is the way to go.
Thank you.