Forum Discussion
Count( if column value = string)
Hi, Having trouble with DAX syntax in if statements for checking if a column's string value equals a certain value. I want to do some calculations using different counts of strings, such as: CO...
Anonymous add new measure with following expression
MyBalanceCount = CALCULATE( COUNTROWS( MyTable ), MyTable[Location] = "In Storage" ) - CALCULATE( COUNTROWS( MyTable ), MyTable[Location] = "Out Storage" )
Anonymous add new measure with following expression
MyBalanceCount = CALCULATE( COUNTROWS( MyTable ), MyTable[Location] = "In Storage" ) - CALCULATE( COUNTROWS( MyTable ), MyTable[Location] = "Out Storage" )