Forum Discussion

guilrosr's avatar
guilrosr
New Member
2 years ago

CALCULATE with FILTER not working

Hi all,  I'm trying to add a FILTER to my CALCULATE formula, but it does not return any values. The filter bases its parameters on the result of the formula:    Overall Average Price = CALCULAT...
Need Help
Arul's avatar
Arul
Icon for Super User rankSuper User
2 years ago

guilrosr ,
Create a variable for average price and use that in calculate filter instead of referring the mesure directly, 

High Ticket_Orders = 
VAR _Overallaverageprice = AVERAGE('Product'[List Price])
VAR _result = CALCULATE(
    [Total_Order],
    FILTER('Product',
    'Product'[List Price]>_Overallaverageprice))
RETURN _result