Distinct Count Grand Total is Incorrect

[rainchong-7401]

Dear Friends,
I would like to need your help.
Grand total is showing 18 
But when I export data to excel it's more than 18
My measure: 

DISC_ADDRESS =

DISTINCTCOUNT(BTM_WMSSHIPMANIFESTLNE[DELIVERYADDRESS])

When I try this other way of doing distinct count also incorrect 

TEST_DISTINCT =

VAR T = SUMMARIZE(BTM_WMSSHIPMANIFESTLNE,BTM_WMSSHIPMANIFESTLNE[SHIPMENTDATE],"DISCADDRESS",DISTINCTCOUNT(BTM_WMSSHIPMANIFESTLNE[DELIVERYADDRESS]))

RETURN

SUMX(T,[DISC_ADDRESS])

Kindly help me ASAP!!!!

[amitchandak · Accepted solution]

@rainchong-7401 , This will depend of the group by used in visual

Try like

TEST_DISTINCT =
VAR T = SUMMARIZE(BTM_WMSSHIPMANIFESTLNE,BTM_WMSSHIPMANIFESTLNE[SHIPMENT ID],BTM_WMSSHIPMANIFESTLNE[DELIVERYADDRESS])
RETURN
Countx(T,[DELIVERYADDRESS])