Forum Discussion
dax function
Good orders = CALCULATE([Order Count],FILTER(table_orders,[Actual order value]>AVERAGE(table_orders[Bill_amt]))) where [Actual order value] = Actual order value = CALCULATE(SUM(table_orders[Bil...
Sir, these are the three measures
1)Actual order value = CALCULATE(SUM(table_orders[Bill_amt]),table_orders[DeliveryStatus]<>"Cancelled")
1)Actual order value = CALCULATE(SUM(table_orders[Bill_amt]),table_orders[DeliveryStatus]<>"Cancelled")
2)Average amount of order = AVERAGE(table_orders[Bill_amt])
3)Good orders = CALCULATE([Order Count],FILTER(table_orders,[Actual order value]>AVERAGE(table_orders[Bill_amt])))
Sir, the result for Good orders is coming out to be 6
My doubt is that in Good orders = CALCULATE([Order Count],FILTER(table_orders,[Actual order value]>AVERAGE(table_orders[Bill_amt]))), isn't [Actual order value] an aggregated value, which is same for all rows.
Regards
It is not an aggregated value because the table you have provided is table_ordes in the Good Orders measure. So the masure is being evaluated for each row. If you want to receive any further help, share some data to work with, explain the question and show the expected result.
Sir, in the similar context when I use the measure [Average amount of order] inside the FILTER function
Good order 1 = CALCULATE([Order Count],FILTER(table_orders,[Actual order value]>[Average amount of order])), you can see in the screen shot the result is coming "blank". Could you please advice why the result is coming blank .Good orders = CALCULATE([Order Count],FILTER(table_orders,[Actual order value]>AVERAGE(table_orders[Bill_amt])))Is there any difference in the working of Good orders and Good orders1I cannot help you by simple looking at a screenshot. Prepare a simple Table and show the expected result for that table.