Combining two rows across SelectedValues

DAX DAX Calculations
1

image

image
Product _ Gross Margin - 2nd Issue.pbix (1.2 MB)

2

Hi,

IF you looking for the below result:
image

For this you need to create a disconnect as in your dax you are filtering the category which on execution time overwrite it .So it give you blank

For your reference i am attaching the pbix :
Product _ Gross Margin - 2nd Issue.pbix (1.2 MB)

1 Like
3

Thanks Anurag, much appreciated! One additional question: It seems I can’t enter sorting values (1,2,3…) into a column that I insert in the new table. How do I do that? Or how do I control sorting of the column?

4

Hi,

if you can provide me a screen shot of your new req and expected result i can help you.
BY the look of your req with help of dax you can insert index column and use that for your sorting task.

Thanks,
Anurag