topic row totals for matrix with concatenatex in DAX Commands and Tips

row totals for matrix with concatenatex

crawlejg — Mon, 31 Jul 2023 15:26:14 GMT

Hello,

FIrst time that I am trying to use DAX to modify a visual in PowerBI. I have a table with some text values that I want to display in a matrix, but i also want to show totals (counts) both by column and by row. I have written the following DAX, which gives me the text in the values of the matrix and totals (counts) by column, but I am still getting a list of text in the totals for rows. Could someone please help me to correct it? Thank you!

My DAX for my measure:

My data:

OrderedStage

1 – First Stage

2 – Second Stage

3 – Third Stage

4 – Final Stage

PRODNumber

ABC123

XYX456

CDE321

The current result:

My desired result:

Thanks,

crawlejg

Re: row totals for matrix with concatenatex

tamerj1 — Mon, 31 Jul 2023 16:11:48 GMT

Hi crawlejg
Use ISINSCOPE ( 'Table'[Group] )

Re: row totals for matrix with concatenatex

crawlejg — Mon, 31 Jul 2023 16:23:39 GMT

Thank you tamerj1,

I updated to ISINSCOPE ( 'Table'[Group] ) and it gave me counts at the bottom, but now the totals on the right are the concatenated text instead of counts. How can I get both totals to be numbers?

Re: row totals for matrix with concatenatex

tamerj1 — Mon, 31 Jul 2023 16:53:13 GMT

crawlejg
Sorry I did not notice the the row totals. Please try

ISINSCOPE ( 'Table'[Group] ) && ISINSCOPE ( 'Table'[OrderedStage] )