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" ) )

     

parry2k's avatar
parry2k
Super User
3 years ago

PowerBIBeginer or something like this:

 

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