Count Distinct Items

[brysonb12]

Trying to do a Count If Measure but dont want to count if it contains other criteria

I have Column A Listed as "WO#" and Column B listed at "WO Type". Under column WO Type I have multiple criteria (T&M or LS)

What I am wanting to do is create a measure that Counts the number of times the WO# appears in T&M but noes not appear in both

Example being 

WO#	WO TYPE
1111	T&M
1111	LS
2222	T&M
3333	T&M
4444	LS

So my number that would show in my card would be T&M - 2

[MahyarTF]

Hi,

Not sure, if I am right ?

1- I create duplicated table in power query :

2- Then Group the WO# column :

3- Apply to the power bi :

4- Create the below measure in main table :

Wo Typ Cnt = count(Sheet85[WO TYPE])

5- then develop the below visual :

* in desired visual, put the count = 1 (use 'Count' column from the duplicated table)

****** Appreciate to Kudos *******

[brysonb12]

I tried that and It did not work. The issue I am running into is this is a data set of a month. So the WO# can show up multiple times a day with multiple people. 

I need it to be able to count the number of times that T&M shows up, but I want **bleep** to EXCLUDE the T&M job number if it has LS wiht it. 

IE - In the example below T&M WO# Count = 2 (because WO#33333 and 44444 ONLY have T&M time)

Timesheet Date	Last Name	WO#	Class
07/01/2022	John	11111	T&M
07/01/2022	John	11111	LS
07/01/2022	Bill	11111	LS
7/8/2022	Bill	22222	T&M
7/8/2022	Lance	22222	LS
7/15/2022	John	333333	T&M
7/15/2022	John	333333	T&M
7/18/2022	Bill	444444	T&M
7/18/2022	Lance	444444	T&M
7/18/2022	Bill	444444	T&M
7/18/2022	Lance	444444	T&M