Hi Everyone,I have to append/ Combine quick measure with other columns in a table.is it possible

[SK16]

Hi Everyone,

In my dashboard I have 6 metrics in one slicer and the 7th metrics is the weighted avgerage

which I have calculated through  a quick measure.

Now i have  to combine all the 7  metrics in single slicer.

Is it possible to do 

Thanks

[v-xicai]

Hi @SK16 ,

You can create a calculated table like DAX below, assuming the [7th metrics] and [6 metrics column] from the same Table1, then let the new column[slicer metrics] as the source of slicer.

Table2= UNION (SELECTCOLUMNS(Table1,"slicer metrics",Table1[7th metrics]),SELECTCOLUMNS(Table1,"slicer metrics",Table1[6 metrics column]))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SK16]

Thanks for your help.

But i want Metrics name and Value Side by Side .

Now its only shows the value.

I want name and value both .

Thanks in advance

[v-xicai]

Hi @SK16 ,

Table2= UNION (SELECTCOLUMNS(Table1,"slicer metrics",CONCATENATE("7th metrics name ",Table1[7th metrics])),SELECTCOLUMNS(Table1,"slicer metrics",CONCATENATE("6 metrics column name ",Table1[6 metrics column])))

If I misunderstood it, could you please share your sample data or desired output screenshots for further analysis, you can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy