Forum Discussion
Vkl
1 year agoFrequent Visitor
Parameter values Duplication Issue
I have aroun 20 calculated measures created that are just the sum for (orders, Orders EX NI) for each respective quarters and years. I created a field parameter for these measures to swictch from the...
MFelix
1 year agoSuper User
Hi Vkl ,
This is a limitation on the field parameters that when you use them in matrix the values get's repeated, instead of adding the names to the rows choose the option show values in Rows:
This should gibve what you need in term of details, but be aware that this will not give you the Field Parameter on top of the row hierarchy this will be at the bottom.
If you want to use it in a matrix you need to use a new table and a switch measure to get this sorting.
Vkl
1 year agoFrequent Visitor
Hi MFelix , Thank you for the help. But The duplication still persist but now its in the columnar level. Can you give an example on utilizing the switch function for the calculated measures where i could also use the metric names such as (Orders, Orders EX NI) in slicers.