How do you display the total number of values in a table without having to count function?

[Anonymous]

Hello,

I was wondering if it is possible to display the number of rows or values (for sales order specifically) without having to use the Count function, since using it would mean that there would be that awkward 1 beside the order number. In other words, how do you only show the total value or number of rows,10?

Thanks!

[AlB]

Hi @Anonymous,

1. You could  create a measure and display it in a card visual rather than on the table/matrix visual:

Measure1 = COUNT(Table1[Sales Order])

Make sure the needed filters are applied to the card visual (probably through slicers)

2. Or you could create another measure that only shows a result at the total and blanks elsewhere. You can use ISFILTERED() to identify where you are. Something along these lines:

Measure2 = 
VAR _Res = COUNT(Table1[Sales Order])
RETURN
IF(NOT ISFILTERED(Table1[Sales Order]), _Res)

[Anonymous]

Hi @AlB, thank you for your help!

I tried out your first suggestion and it did work. However, I am trying to make everything as compact as possible. 
I tried out the second suggestion and the whole table became empty.

Also, I should have given a bit more context. I applied a visual filter to the table, where it only shows negative values for the variable, DATEDIFF. Perhaps, this might require another specific DAX formula.

Thanks!

[AlB · Accepted solution]

@Anonymous 

If all values in the table visual disappear it probably has to do with what you have in the visual level filter. I'd need to see the details for that: whether you are using a measure for that and if so its code and otherwise how you are setting up the filter. It would also help if you show the structure of the tables involved in the table visual. If you can share the pbix, that'd be best. 

In any case, bear in mind that with this second option you would still have the whole column with blanks and only filled in at the total. I'm not sure that's what you want?

Cheers 

[Anonymous]

Hi @AlB,

I managed to obtain the total number with the blanks,from slightly tweaking your formula. 

Thank you!