row totals for matrix with concatenatex

[crawlejg]

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

[crawlejg]

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?

[tamerj1 · Accepted solution]

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

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

[tamerj1]

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