Dax help

[PowerBIBeginer]

Hi All,

I need small help in Dax please.. How do I rewrite this dax in correct way.. pls guide..

tpa removal rows = CALCULATE(COUNT('table1'[ID]),
FILTER('table1','table1'[Name]<>"*tpa*"),
FILTER('table1','table1'[Name]<>"tpa"),
FILTER('table1','table1'[Name]<>"*tpa"),
FILTER('table1','table1'[Name]<>"tpa*")
)

[PowerBIBeginer · Accepted solution]

@Greg_Deckler @parry2k 

No I didnt undestand.. See this is how I used..

tpa removal rows = 
VAR __Result = CALCULATE ( COUNTROWS( 'table1' ), NOT 'table1'[Name] IN {"*tpa*", "tpa", "*tpa", "tpa*" } )
RETURN
  __Result

[PowerBIBeginer · Accepted solution]

Did I used it correctly? Pls let me know, since I dont understand the syntax.. after countrows do I use table name or column name?

tpa removal rows = 
VAR __Result = CALCULATE ( COUNTROWS( 'table1' ), NOT 'table1'[Name] IN {"*tpa*", "tpa", "*tpa", "tpa*" } )
RETURN
  __Result

[ThxAlot · Accepted solution]

= CALCULATE( COUNTROWS( Table1 ), NOT CONTAINSSTRING( Table1[Name], "tpa" ) )

[parry2k]

@PowerBIBeginer table name

[parry2k]

@PowerBIBeginer I think it is worth asking what you are trying to achieve. Share sample data with the expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[parry2k]

@PowerBIBeginer 

let's use the Name column in the table visual and then above measure, it will remove TPA rows.

[PowerBIBeginer · Accepted solution]

@Greg_Deckler @parry2k 

No I didnt undestand.. See this is how I used..

tpa removal rows = 
VAR __Result = CALCULATE ( COUNTROWS( 'table1' ), NOT 'table1'[Name] IN {"*tpa*", "tpa", "*tpa", "tpa*" } )
RETURN
  __Result

[PowerBIBeginer · Accepted solution]

Did I used it correctly? Pls let me know, since I dont understand the syntax.. after countrows do I use table name or column name?

tpa removal rows = 
VAR __Result = CALCULATE ( COUNTROWS( 'table1' ), NOT 'table1'[Name] IN {"*tpa*", "tpa", "*tpa", "tpa*" } )
RETURN
  __Result

[PowerBIBeginer]

Hi Greg, Hi Perry,

Thanks for such a quick and pretty soluton. But I dont understand 

RETURN __Result

return __result is what? means in my case what will be there? 

[parry2k]

@PowerBIBeginer or something like this:

tpa removal rows = 
VAR __Result = CALCULATE ( COUNTROWS( __Table ), NOT 'table1'[Name] IN {"*tpa*", "tpa", "*tpa", "tpa*" } )
RETURN
  __Result

[Greg_Deckler]

@PowerBIBeginer You could do this:

tpa removal rows = 
  VAR __Table = 
    FILTER( 
      'table1',
      'table1'[Name]<>"*tpa*" && 
      'table1'[Name]<>"tpa" &&
      'table1'[Name]<>"*tpa" &&
      'table1'[Name]<>"tpa*"
    )
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result