Add Metric Twice to matrix table but only change 1 element

eliasayyy — Wed, 29 Mar 2023 11:07:12 GMT

Hello everyone,

i have a matrix table

the row shows category , sub categoy

the values show the same measure "Total Impression" Twice

Total Impression = SUM('Table'[Impressions])

so my matrix table has 3 columns in theory "Category" which can be drilled down to sub category , "Total Impression" and "Total Impression" again

the reason i want the same measure twice is because i want to be able to add data bars to the send one without value

this will let me have the first column Impression to show the number and the second column Impression will act like a data bar chart label

but when i select cell elements and want to do this, it only appears once.

how can i acheive my goal

Re: Add Metric Twice to matrix table but only change 1 element

lbendlin — Sun, 02 Apr 2023 00:21:01 GMT

That should work. Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

topic Re: Add Metric Twice to matrix table but only change 1 element in DAX Commands and Tips

Add Metric Twice to matrix table but only change 1 element

Re: Add Metric Twice to matrix table but only change 1 element