Forum Discussion
Countrows 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? | 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
1 Reply
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.
