Countrows for calculated measure

[ManjunathaEP]

Hi, Thank you in advance for your support on this. I have data table as mentioned below and I would like to calculate the countrows of a column from the calculated measure:

Cust.Name	Y/N?	Amount	Rev.Class
XYZ	Y	123	Apple
ANF	Y	344	Apple
ABC	Y	555	Mango
JUF	Y	222	Apple
KIF	Y	33	Mango
JUS	Y	55	Mango
KFF	Y	7676	Orange
LSF	Y	33	Apple
XYZ	N	66	Mango
ANF	N	77	Orange
SRE	N	88	Mango

I calculated the measure = calculate(sum('Table'[Amount]),FILTER(VALUES('Table'[Cust.Name]),CALCULATE(DISTINCTCOUNT('Table'[Y/N?])>1)))

Now: I would like to calculate the countrows of "Rev.Class" column, which is equal to the above measure

[ManjunathaEP]

The requirement is on the count of orders. please find the calculated measure as given below:

order No	Cust Name	Y/N?	Revenue class	Amount
111	ABC	Y	Apple	100
112	XYZ	N	Apple	22
113	ABC	N	Apple	300
114	XYZ	Y	Orange	66
115	DFG	N	Apple	667
116	DDF	Y	Orange	567
112	XYZ	N	Mango	345
111	ABC	Y	Mango	349

I have calculated a measure = calculate(DISTINCTCOUNT('Table'[order No]),FILTER(VALUES('Table'[Cust.Name]),CALCULATE(DISTINCTCOUNT('Table'[Y/N?])>1))) and I got the answer "4" orders.

Now: I would like to get count of orders by Rev.Class. In the given example: The answer should be Apple=2, Mango=2. My requirement here is to calculate the count of orders by Rev.class, which is equal to the calculated measure above.