to show Running count of account number in Drill through report

[sameer_K]

We have a drill through report for account details and in that we  wanted to show the running count of account number by account holder name. I tried using Quick measure but in that way its not showing the drill through report. Any suggestions ?

Thanks you in advance 

[Anonymous · Accepted solution]

Hi @sameer_K ,

You can try the following steps:
1. Create a calculated column.

Column =
RIGHT('Table'[Claim Number],3)

2. create the measure.

RunningCount =
CALCULATE(
COUNTROWS('Table'),
FILTER(
ALLSELECTED('Table'),
'Table'[Bank] = MAX('Table'[Bank]) &&
'Table'[Column] <= MAX('Table'[Column])
)
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[sameer_K]

 Please find the sample data and end result snap below 

[Anonymous]

Hi @sameer_K ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[sameer_K]

Thanks for the reply Clara... Sample data and end results are as below 

[danextian]

hi @sameer_K

What is a "running count of account number by account holder name"? Is that the distinct account numbers under the same accoun holder or a cumulative count over several time periods?

[Idrissshatila]

Hello @sameer_K ,

you create a measure to count the running accounts as follows:

Account Count = DISTINCTCOUNT(TableName[AccountNumber])