Using Summarize with Countrows and Filter Functions in a Dax Measure

No need for summarize - better stay away from that function, it has lots of dirty secrets

Hi,

Try this

#Records = Countrows( Filter( Summarize ('Order Data', 'Order Data'[Order Number], 'Order Data'[Status]), [Status] = "Delivered")) 

Hi newpbiuser01 

Thank you very much Ashish_Mathur and lbendlin for your prompt reply.

I checked your code carefully and the problem is that there is an extra ")" in the screenshot position. You can try to modify it.

The correct code should be as provided by Ashish_Mathur.

Or you can try the method provided by lbendlin which will also give you the results you want.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.