Forum Discussion
Solved
Distinct Count Grand Total is Incorrect
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!!!!
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])
1 Reply
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])