Forum Discussion
ManjunathaEP
Helper II
Helper IICountrows for calculated measure
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? Am...
ManjunathaEPHelper II
Helper IIThe 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.