Calculate total number of game

[ghada9934]

Hello there, 

I have a question I just tried to calculate the total number of games for all teams but it did not work!

[v-cazheng-msft · Accepted solution]

Hi @ghada9934 ,

Not very sure about what your Curry tale looks like, so I create some sample data per the description.

Then, create a Calculated column to count the number of games.

Total Number Game = CALCULATE(COUNT(Curry[date]),TREATAS(VALUES('Table'[Abbreviation]),Curry[opposing team]))

The result looks like this.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[amitchandak]

@ghada9934 , Assume team is franchise

then a new column =

countx(filter( Table, [franchise] =earlier([franchise]) ,[franchise])

or measure

countx(filter( allselected(Table), [franchise] =max([franchise]) ,[franchise])

[ghada9934]

It doesn't work! It gives me an error

I have another table called 'Curry' that includes Date column and season cloumn

curry team played many times against the same opposing team in one season

so, I assume we need to use Date and Season column 

[daXtreme]

Here's the best advice anyone can give you: How to Get Your Question Answered Quickly (powerbi.com)