Forum Discussion
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
#Records = Countrows(SUMMARIZECOLUMNS('Order Data'[Order Number],TREATAS({"Delivered"},'Order Data'[Status])))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.
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.