Forum Discussion

anithfanz's avatar
anithfanz
New Member
4 years ago

Count Occurrence with two filters

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

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

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

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.