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" )
Hamza_Meknassi you can do this too:
del =
CALCULATE (
COUNTROWS(dashboard ),
dashboard[code] IN { "RES", "DES" }
)
Subscribe to my youtube channel https://youtube.com/@PowerBIHowTo