Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@Anonymous ,
if(isinscope(Table[casenumber), max(Table[casenumber]), count(Table[casenumber]))
or
if(isfiltered(Table[casenumber), max(Table[casenumber]), count(Table[casenumber]))
@Anonymous , You can use isfiltered. But That also need two measures
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Thanks @amitchandak can you please explain what the other measure would be , the article is not that clear.
@Anonymous ,
if(isinscope(Table[casenumber), max(Table[casenumber]), count(Table[casenumber]))
or
if(isfiltered(Table[casenumber), max(Table[casenumber]), count(Table[casenumber]))
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |