The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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 |
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |