sum of countdistrict by day

[daedah]

excuse me, please

I trying to calculate dax formula for districtcount by day

I use formula 

10W = ((CALCULATE(DISTINCTCOUNT(Driver[AUTO_PLATE_ID]),FILTER(Driver,Driver[AUTO_TYPE]="10 W"),Driver[BILL_DATE]))

Result

but it mistake  it correct is 255 but it show 15

Link for raw data 

https://drive.google.com/file/d/1As1Gcr-jZtm6VuZdDZpZ1hFkp2knV-jl/view?usp=sharing

Thank you for your help

[Anonymous]

Hi, @daedah 

I would like to help you but could you upload your raw data to OneDrive For business if possbile?

Paul

[daedah]

https://1drv.ms/x/s!AutMLdSC0cXig3Vq8pCVpw9aAkm9?e=GjaqeI 

[Anonymous]

Hi, @daedah 

The excel data is different to yours, so my results is also differed. For the number "15", it is the distinctcount of Auto_PLATE_ID. 

I am not sure about what is the number 255. Could you clarify? Thank you.

Best,
Paul

[daedah]

yes please,

As picture , 255 from  4+8+7+8+11+7+6+7+6+7+8+9+5+5+....  or sum of result in everyday (According time selected , month , year)

Thank you for ypur help

[Anonymous · Accepted solution]

Hi, @daedah 

I have spent some time on the fixing the outcomes. I am afraid it is not possible to sum up the DistinctCount measure by day. 
Therefore, I figured out an alternative (Calculated Column and Slicer) to your expected results despite the formula does not make much sense: 

10W Column=
CALCULATE (
    DISTINCTCOUNT ( Transport[AUTO_PLATE_ID] ),
    FILTER (
        ALLEXCEPT ( Transport, Transport[BILL_DATE] ),
        Transport[AUTO_TYPE] = "10W"
    )
)
    / CALCULATE (
        COUNTROWS ( Transport ),
        FILTER (
            ALLEXCEPT ( Transport, Transport[BILL_DATE] ),
            Transport[AUTO_TYPE] = "10W"
        )
    )

44 and 2388 are corresponding to 15 and 255 in your case.  

Hope it helps you in some extend. 

Best regards,

Paul Zheng

[daedah]

Thank you for your help