Forum Discussion

ABookbin's avatar
ABookbin
Frequent Visitor
5 years ago
Solved

Filtering out negative values

Hello,    I have a transportation data set that has many faulty data points. In the table below, I have averaged the 'actual transit days' by city-city pair, but somewhere within the data set there...
average
Filter
  • Fowmy's avatar
    Fowmy
    5 years ago

    ABookbin 

    Build your measure this way:

    HISTORIC AVERAGE = 

CALCULATE(

	AVERAGE( TABLE[ACTUAL TRANSIT DAYS]),
	ALLEXCEPT( TABLE, TABLE[CITY-CITY-PAIR),
	TABLE[ACTUAL TRANSIT DAYS] > 0
)
Fowmy's avatar
Fowmy
Super User
5 years ago

ABookbin 

Build your measure this way:

HISTORIC AVERAGE = 

CALCULATE(

	AVERAGE( TABLE[ACTUAL TRANSIT DAYS]),
	ALLEXCEPT( TABLE, TABLE[CITY-CITY-PAIR),
	TABLE[ACTUAL TRANSIT DAYS] > 0
)