Hello @SriKandimalla ,
If I understand your issue, try this:
Countrows = CALCULATE(COUNTROWS(crow),ALLEXCEPT(crow,crow[categories]))
crow is my table name.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!