chakravarthypsk
New Member
- Joined
- Feb 19, 2021
- Messages
- 3
- Office Version
- 2013
- Platform
- Windows
Greetings to All!
I have a IPL dataset, wherein i trying to calculate the total number of wins for each team
i used the below DAX formula
var result = SELECTEDVALUE('IPL Matches 2008-2020 (1)'[winner],"no value selected")
return
calculate(
countrows('IPL Matches 2008-2020 (1)'),
filter(
ALL('IPL Matches 2008-2020 (1)'),
'IPL Matches 2008-2020 (1)'[team1]=result))
however, it is showing complete blank values and no value is being displayed. Hence, please suggest.
I have a IPL dataset, wherein i trying to calculate the total number of wins for each team
i used the below DAX formula
var result = SELECTEDVALUE('IPL Matches 2008-2020 (1)'[winner],"no value selected")
return
calculate(
countrows('IPL Matches 2008-2020 (1)'),
filter(
ALL('IPL Matches 2008-2020 (1)'),
'IPL Matches 2008-2020 (1)'[team1]=result))
however, it is showing complete blank values and no value is being displayed. Hence, please suggest.