Show in the "total row" the rows count

[aser1958]

How can I display in the "Total Row" the count of "mTitle"

[speedramps]

Download this solution

Click to download PBIX from OnedDrive 

How it works ...

This measure returns blanks when the title is filtered and the distinct count when on the total.

You can replace distint count with count depending if you wish to include or exclude film remakes with the same title.

Titles = 
IF( NOT ISFILTERED(yourdata[Title]),
DISTINCTCOUNT(yourdata[Title]))

Then hide the heading for that measure, so it looks like a hanging total

Thanks for the clear description of the problem with example data. I wish everyone did that!

Remember we are unpaid volunteers, and you have got free expert help which took a lot of effort,
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos. 

One question per ticket please. If you need to change or extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

If you quote @speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

Please now click the [accept as solution] and the thumbs up button.  Thank you.

[amustafa]

Here's how to create a new DAX measure to count rows by each value in your column 

RowCountMeasure :=
CALCULATE(
COUNTROWS('YourTable'),
ALLEXCEPT('YourTable', 'YourTable'[mTitle])
)