DAX Calculation

[Arul]

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. 

[v-juanli-msft]

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]

But, It gave me the wrong result as 68.

[v-juanli-msft]

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

[Arul]

This the result which i got when i used the formula which was shared by you.

[v-juanli-msft]

Hi @Arul 

It seems "is_super_over" doesn't exsit in the same table with "match id".

Please let me know which table "is_super_over" lies and what relationship between two tables which  "is_super_over" column and "match id" column lie.

You could give me an simple data example.

Best Regards

Maggie

[Arul]

Hi @v-juanli-msft

They are in the same table only.