hi

[abc_777]

hi,

I have reg_no column where vehicle registration are there.

I count them. but my total shows 1.

i want to count and then total need to show as sum of total count

nswer would be 35 (total of count)

please help

Sorry i have to mark red as this is sensitive data

thanks 

[djurecicK2]

Hi @abc_777 ,

 The reason the count is 1 is becuase that is the count for each individual customer. If you want to show the total for all customers, you can use ALL(Tablename) as a filter in your measure:

https://learn.microsoft.com/en-us/dax/all-function-dax

[abc_777 · Accepted solution]

i do

CALCULATE(COUNT('bm_retail_t vehicle'[REG_NO]), ALL('bm_retail_t ssummary'[CUSTOMER_NAME]))

but no luck. would be able to give me a simple sample ile for grand total please if possible

thanks