Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Excluding rows from Calculated table

Hi All,   I need to create a new table with DAX, excluding rows where STATE = STATE1 AND BRAND = BRAND1   Here is my dummy data: Table1 STORE STATE BRAND ANSWER STORE1 STATE1 BRAND1 ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    I loaded your data into a table 'Table1' 

    Then created a Table2 using the measure

    Table2 = FILTER ( Table1, NOT ( Table1[STATE] = "State1" && Table1[BRAND] = "Brand1" ) )

     Leaving a table with no row that is a State1 Brand1 row.  Was that what you were looking for?

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hii RobinDeFal

 

You want like this.....?

 

Table2= CALCULATETABLE(Table1,FILTER(Table1,Table1[STATE]<>"STATE1"),Table1[BRAND]<>"BRAND1")