Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

dax equivalent to select not In same table with where condition

Hi All, I have table that has log that has records for same stores which are open,closed. I want to select stores which are not closed   I am looking for Dax equivalent  for following query SQL: s...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 
    You need to create a calulated table not a measure

    Go to modeling tab

    click on new table 

    and paste following formula

    Reports =

VAR _values = CALCULATETABLE(VALUES(PowerBIAuditLog[ReportName]),PowerBIAuditLog[Activity]="DeleteReport")
RETURN
CALCULATETABLE(VALUES(PowerBIAuditLog[ReportName]),NOT(PowerBIAuditLog[ReportName]) IN _values)

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous Make sure you are pulling right fields in table. I don't see any of the delete report in new table. If you are using the same data which I have used then you should get 269 records in new table.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Vimal,

Could you share me report file which you are using. I am not sure what wrong I am doing here.