Forum Discussion

Arul's avatar
Arul
Super User
7 years ago

DAX Calculation

 

 

Hi all,

I want to count the super over by the match id. Here in the dataset they were given the particular column for the super over and if super over is bowled 1 was entered in the particular row for every ball of that super over with the respective match_id. 

NOTE: match_id was given to the every ball of the match. Pls refer the above image to solve my problem. 

Need Help

6 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Arul 

    Per your requirement, you could create a column or a measure

    Column = CALCULATE(SUM(Sheet2[is_super_over]),ALLEXCEPT(Sheet2,Sheet2[match_id]))

Measure = CALCULATE(SUM(Sheet2[is_super_over]),ALLEXCEPT(Sheet2,Sheet2[match_id]))

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Arul's avatar
      Arul
      Super User
      7 years ago

      But, It gave me the wrong result as 68.

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi Arul 

        Do you create a column or a measure?

        Could you show an exmaple for me to work on?

        It is better for you to share the screenshot which show the wrong result.

         

        Best Regards

        Maggie