Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 |
Solved! Go to Solution.
Hi, try with this:
DCMeasure = SUMX(VALUES(Table1[Exterprise]);DISTINCTCOUNT(Table1[Environment]))
Hi, try with this:
DCMeasure = SUMX(VALUES(Table1[Exterprise]);DISTINCTCOUNT(Table1[Environment]))
Thanks this helped.