How to Calculate Distinct Count of Account Name that are Closed

[Anonymous_KH]

Hi All 

I need a Dax Funtion that will Calculate Distinct Count of Account Name that are Closed

  Stage                Account Name

Closed	police mutual
Open	Adi Group Ltd
Open	NS Clarke Transport Limited
Closed	Hepworth Fabrication
Closed	Vacuum Furnace Engineering Ltd
Open	Thermoseal
Open	Purity Brewing Co Limited
Open	Brockhouse Group Ltd
Open	Vanguard Foundry Ltd
Open	Salop Leisure Holdings Ltd.
Open	Lake Chemical & Minerals Ltd
Closed	police mutual
Closed	police mutual
Closed	Elliott Nash Limited

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture.

It is for creating a measure.

Expected result measure: = 
CALCULATE( DISTINCTCOUNT(Data[Account Name]), Data[Stage] = "Closed")