Count games

[Mathias]

Hello everyone,

so...

Fact Table:

Dim Home_team

Dim Away_team

And a variable value team_select="Team 2"

I want a KPI that represents how many times that Team 2 played "home" and a KPI that represents how many times that Team 2 played "away". What is the Expression that I have to use?

Thanks!

[sunny_talwar]

May be this

Times Team 2 played "home"

Count({<home_team_id = {2}>}ID)

Times Team 2 played "away"

Count({<away_team_id = {2}>}ID)

[Mathias]

I have to do it with the variable because It is possible to change the variable in the app