Forum Discussion
Solved
Distinct Count of Measure Column
Hello, I want to calculate Disticnct count of Column1 based on Column2. I added a Measure Column
DISTINCTENV = DISTINCTCOUNT(Sheet1[Environment]) which gives below output.
Original Table:
| Date | Exterprise | Environment | Application |
| Mar-17 | ANBC | DV1 | APP1 |
| Mar-17 | ANBC | DV1 | APP2 |
| Mar-17 | ANBC | DV2 | APP3 |
| Mar-17 | ANBC | DV2 | APP4 |
| Mar-17 | ANBC | DV2 | APP5 |
| Mar-17 | ANBC | DV2 | APP6 |
| Mar-17 | ANBC | DV3 | APP7 |
| Mar-17 | CNBC | DV1 | APP8 |
| Mar-17 | CNBC | DV2 | APP9 |
| Mar-17 | CNBC | DV3 | APP10 |
Table after adding MEasure. But Total is coming 3. It should be 6. How can Count Sum of Measure column?
| Enterprise | Measure |
| ANBC | 3 |
| CNBC | 3 |
| Total | 3 |
Hi, try with this:
DCMeasure = SUMX(VALUES(Table1[Exterprise]);DISTINCTCOUNT(Table1[Environment]))
2 Replies
Hi, try with this:
DCMeasure = SUMX(VALUES(Table1[Exterprise]);DISTINCTCOUNT(Table1[Environment]))
Thanks this helped.
