Forum Discussion
Helper Iusing field parameters as a value in TopN
Hi team,
I am using Field Parameters to switch between measures in a stacked chart.
One requirement that I have is to calculate TopN.
My issue is that the field parameters cannot be used as a value in the filters on this visual.
How can I calculate TopN based on any measure that's being used?
Thank you.
Regards!
I was able to accomplish this by using
switch
(selectedvalue (measure parameter order),
0, [ measure 1 ],
1, [ measure 2 ],
etc
)
5 Replies
SeGrI was able to accomplish this by using
switch
(selectedvalue (measure parameter order),
0, [ measure 1 ],
1, [ measure 2 ],
etc
)
Hi SeGr ,
Have you resolved the issue now? If so, please kindly mark your answer as a solution to close the case and help more people find the solution.
If I have misunderstood your meaning, please provide some sample data without privacy information and your desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have a question. Do I need to create a new measurement for this? Thank you.
You have to create a new measure. I could solve the problem by creating the measure like this:
Measure = SWITCH(SELECTEDVALUE(ParameterTable[Parameter Order]),0, [Measure1],1, [Measure2])Note: You have to use the order of the parameter ([Parameter Order]) as the argument of SELECTEDVALUE function, to use the index (0, 1, 2, ...) of the parameter in SWITH function.For example, if you have a parameter like this:CostRevenue = {("Cost", NAMEOF('Sales'[CostSum]), 0),("Revenue", NAMEOF('Sales'[RevenueSum]), 1)}The Measure you have to create and use as TopN filter will be:CostRevenueForTopN = SWITCH(SELECTEDVALUE(CostRevenue[CostRevenue Order]),0, 'Sales'[CostSum],1, 'Sales'[RevenueSum])Thanks!Thanks for your reply, it helped me with an issue of selecting TopN by parameters that applied to many different visuals!
