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...
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 orders1
I cannot help you by simple looking at a screenshot. Prepare a simple Table and show the expected result for that table.