Distinct Count of Measure Column

[mrvamsidhar]

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

[Vvelarde · Accepted solution]

@mrvamsidhar

Hi, try with this:

DCMeasure = SUMX(VALUES(Table1[Exterprise]);DISTINCTCOUNT(Table1[Environment]))

[mrvamsidhar]

Thanks this helped.