Distinct Count of unique values in one column based on unique values in another column

[veefly21]

New to Power Bi

I am trying to count unique values (2 values) in one column based off unique values in another column. I have two columns, one is type and the other is Chargeable incident. I am trying to get a count when column type has sms and the chargeable incident column has either osha or osha_lti.  With the below data, I would like to get a count of 3. There is always a vaule in the type column, but not in the chargeable column. 

Thank you in advance

Type	Chargeable incident
sms	osha
tms	osha
sms	osha_lti
tms
sms
sms	osha
tms	osha_lti
mms
mms	osha

[negi007 · Accepted solution]

@veefly21  you can create a measure like below

Count_Chareable = CALCULATE(COUNT('Table'[Chargeable incident]),'Table'[Chargeable incident]="osha" || 'Table'[Chargeable incident]= "osha_lti")

[veefly21]

Thank you. I got it to work. It was user error on my part, I was still not getting the results that you showed me. Finally got it. I am going to need a lot more pratice and learning to get better. 

[veefly21]

Thank you for your help. I have that measure that captures the total osha and osha_lti on a card. I wanted to add another card that only shows the osha and osha_lti that are assoicated with only sms. So I would have one card showing total osha and osha_lti (6) and another card showing only osha and osh_lti associated with sms (3). Tried to use calculate count with an && and a ||  with 2 columns and did not work. The error was due to using two columns.    

[HarishKM · Accepted solution]

@veefly21  adding to @negi007 measures.
you can use below measure
1st requirement =  CALCULATE(distinctCOUNT('Table'[Chargeable incident]),'Table'[Chargeable incident]="osha" || 'Table'[Chargeable incident]= "osha_lti")


2nd requirement with sms =  CALCULATE(distinctCOUNT('Table'[Chargeable incident]),'Table'[Chargeable incident]="osha" ,Table'[Chargeable incident]= "osha_lti", type = "SMS" )

to get value with SMS.

Give Kudos if above solution as per your requirement.

Thanks /

Harish Mishra

[negi007 · Accepted solution]

@veefly21  you can create a measure like below

Count_Chareable = CALCULATE(COUNT('Table'[Chargeable incident]),'Table'[Chargeable incident]="osha" || 'Table'[Chargeable incident]= "osha_lti")