removing unused rows from a dax table..

[JamesBowdidge]

Hi,

using the following DAX table..

SalesTable = groupby(SELECTCOLUMNS(data1,
"Booked Date",data1[ApptDateNotime],
"SlotType", data1[SlotType],
"Sale Count",data1[ApplicantCount],
"Site",data1[ServiceCentreName],
"Appointment £Rev",if(data1[SlotType]="standard",data1[ApplicantAppointmentNetAmount],blAnk()),
"Express £Rev",if(if(data1[SlotType]="express",data1[ApplicantAppointmentNetAmount],blAnk())>110,110,blank())),
[Booked Date],[Sale Count],[Site],[SlotType],[Appointment £Rev],[Express £Rev])

And I want to remove rows that meet a criteria..

If "appointment £Rev" = 0 & "Express £Rev" = blank() then do not return the row

is this possible, cant seem to find a related post, apologies if there is one...

thanks 

J

[Shaurya · Accepted solution]

Hi @JamesBowdidge,

You can use:

SalesTable = groupby(SELECTCOLUMNS(
FILTER(data1,NOT(If "appointment £Rev" = 0 & "Express £Rev" = blank())),
"Booked Date",data1[ApptDateNotime],
"SlotType", data1[SlotType],
"Sale Count",data1[ApplicantCount],
"Site",data1[ServiceCentreName],
"Appointment £Rev",if(data1[SlotType]="standard",data1[ApplicantAppointmentNetAmount],blAnk()),
"Express £Rev",if(if(data1[SlotType]="express",data1[ApplicantAppointmentNetAmount],blAnk())>110,110,blank())),
[Booked Date],[Sale Count],[Site],[SlotType],[Appointment £Rev],[Express £Rev])

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI