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[DEL...
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])
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])