Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
I have to do it with the variable because It is possible to change the variable in the app