How to get total count for rank in the grant total of powerbi table visual?

[bharathiscripps]

Hi All,

I have created a Rank measure and using that in a table visual. At the bottom in the Total for Rank there is 1. Can I get the total count there instead of 1? If not is there a way I can hide just that without removing Total Revenue?

Thank you,

Bharathi

[bharathiscripps]

Hi @DataVitalizer 

Please ignore my last response.

Your suggestion works.

Thank you,

Bharathi

[bharathiscripps]

Hi @DataVitalizer 

Thank you for the response.

I want to replace the 1 with, for this case 1792. How do I replace the total in table with DAX ?

Regards,

Bharathi

[DataVitalizer · Accepted solution]

Hi @bharathiscripps 

Lets say your current measure is Rank=formula, create a new measure using this Dax code

NewRank= 
var myrank=[Rank]
Return if(hasonevalue(Advertiser), myrank, count(Table[Advertiser]))

Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated