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 created 'Dynamic Dimension' field parameter table where I add all dimension which I want to selecte via slicer.
I want on report when select 'Dynamic Measure' and 'Dynamic Dimension' to create dynamic calculation.
Please provide me some advice for this problem??
This approach work when create separate measures for all dimension, but if that is possible I want to apply all in one dynamic measure. Thank you!
3 Replies
Hello,
Have you marked your table and column as a field parameter column?
If so, why don't you drag and drop the field parameter column in your visual, and it should work. For the slicers as well, you can create an extra column with the specific user-friendly names you want to have for each measure and use that column as a slicer.Your table and field parameters should have this mark.
Please let me know if I am missing something
Thank you.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.
