Count Occurrence with two filters

[anithfanz]

Hye,

I have an issue in finding a solution for this problem.

I need to calculate the number of truck arrive filtered by week, and the truck specification is as below.  But I can't seem to find a correct formula for this, can anyone help me?

Truck Size              Occurence by week

1 Tonne

3 Tonne

5 Tonne

10 Footer

20 Footer

40 Footer

[v-xiaotang]

Hi @anithfanz 

Have you solved this question with lbendlin's help? If you still need more help, please provide

(1) some sample data that fully covers your issue/question

(2) give your expected result based on the sample you provide

Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

There's a DAX function COUNTROWS() that you can use in your measure as needed.  Or use the standard "Count"  aggregation in some visuals.