Solved: How to Calculate Distinct Count of Account Name th...

Anonymous_KH · ‎09-23-2022

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 · ‎09-23-2022

Hi,

Please check the below picture.

It is for creating a measure.

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎09-23-2022

Hi,

Please check the below picture.

It is for creating a measure.

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

How to Calculate Distinct Count of Account Name that are Closed