Forum Discussion
dax equivalent to select not In same table with where condition
Anonymous
You need to create a calulated table not a measureGo 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)
Reports =
VAR _values = CALCULATETABLE(VALUES(PowerBIAuditLog[ReportName]),PowerBIAuditLog[Activity]="DeletedReport")
Hi Vimal,
I am getting same error after changing the formula to Reportname.
Here is the Sample data for the reference
| ReportName | Activity | CreateDate |
| Backorder Dashboard | CreateReport | 2/09/2019 0:00 |
| Backorder Dashboard | CreateReport | 12/09/2019 0:00 |
| Backorder Dashboard | CreateReport | 7/11/2019 0:00 |
| Backorder Dashboard | DeleteReport | 3/09/2019 0:00 |
| BCP Standard Pricing | CreateReport | 7/08/2019 0:00 |
| BCP Standard Pricing | DeleteReport | 7/08/2019 0:00 |
DAX Formula:
Reports =
Anonymous I'm able to create table with the sample data you have provided and as per your logic I'm getting zero record
One more thing in sample data in activity column your value is DeleteReport whereas in your formula you have written DeletedReport. Is it possible to share pbix after masking sensitive data?
.Hi Vimal,
Here is the sample file. I have created measure called Reports and its still giving me error.
Anonymous
You need to create a calulated table not a measureGo 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)