Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Hi, @daedah
I would like to help you but could you upload your raw data to OneDrive For business if possbile?
Paul
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
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
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
Thank you for your help
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |