How to remove the "Total" row in custom DAX table

[hxkresl]

the code for custom table is returning a total (6996) row, which is undesireable.   How to change DAX so it doesn't appear?

#ReportAttributeCount = SELECTCOLUMNS(
                           SUMMARIZECOLUMNS(
                           'Report-AttributeMap'[Report Name],
                           "rptA - Total Attributes", COUNTROWS('Report-AttributeMap')
                           ),
                             "ReportA", 'Report-AttributeMap'[Report Name],
                             "rptA - Total Attributes", [rptA - Total Attributes]
)

[v-sihou-msft]

@hxkresl

I haven't encountered this issue.

What's your data source?

If you are using Excel, try to use Table1 instead of Sheet when importing data so that the entire table context will not be included.

Regards,

[hxkresl · Accepted solution]

Thanks for your time. I discovered the 6996 is coming in because that many rows in source table have Report Name and AttributeNames blank.  So, afterall this isn't a total issue.  My error.