Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Helper V
3 years ago
Solved

Dax help

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*"), FILT...
Need Help
  • PowerBIBeginer's avatar
    PowerBIBeginer
    3 years ago

    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's avatar
    PowerBIBeginer
    3 years ago

    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's avatar
    ThxAlot
    3 years ago

     

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

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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