Parameter values Duplication Issue

[Vkl]

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 slicer. In the parameter table, i have created 3 caclualted column (Name, Quarter, Year) all split from the main parameter column. Now when i add the main parameter column in values and the Names column in Rows field in the Matrix visual, you can see in the image, the numbers duplicate in columns. But when i remove the Name column from the Rows field in matrix. The columns field are fine. I want to keep the Name column in the Matrix and remove this duplication in both Rows.

Any idea how this can be achieved?

[Anonymous]

Hi @Vkl ,

Whether the advice given by MFelix has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

[MFelix]

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]

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.