How to get the total at the bottom for non numeric fields

[Anonymous]

Hi All,

I have a report where i want to get the total at the bottom. The issue is the column is not numeric , it is case number. I need the count(casenumber) as a total. I created a new measure (GrandTotal), but that will be just another column. Please see the below screen shot.

Please advice.

Thanks

[amitchandak]

@Anonymous , You can use isfiltered. But That also need two measures

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Anonymous]

Thanks @amitchandak can you please explain what the other measure would be , the article is not that clear.

[amitchandak · Accepted solution]

@Anonymous ,

if(isinscope(Table[casenumber), max(Table[casenumber]), count(Table[casenumber]))

or

if(isfiltered(Table[casenumber), max(Table[casenumber]), count(Table[casenumber]))

[Anonymous]

Thanks @amitchandak that worked !