Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous add new measure with following expression

     

    MyBalanceCount = 
CALCULATE( COUNTROWS( MyTable ), MyTable[Location] = "In Storage" ) -
CALCULATE( COUNTROWS( MyTable ), MyTable[Location] = "Out Storage" )
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous add new measure with following expression

 

MyBalanceCount = 
CALCULATE( COUNTROWS( MyTable ), MyTable[Location] = "In Storage" ) -
CALCULATE( COUNTROWS( MyTable ), MyTable[Location] = "Out Storage" )
  • Hamza_Meknassi's avatar
    Hamza_Meknassi
    Regular Visitor
    3 years ago

    can we have two calculate in the same DAX query ? in my case, i have a syntaxe error !

    del =
    CALCULATE (
    COUNTROWS(dashboard ), dashboard[code] = "RES"
    ) + CALCULATE (
    COUNTROWS(dashboard ), dashboard[code] = "DES"
    )