Countrows IF

[youconnect]

Hi,

Here my table:

Outcome expected: 3
I want Count Rows if id3=3 but alone. If I have id2 with id3 = 2 or 3 I don't want count these. I only want count if id3 = 3 and it's alone in id2.

Can you help me?

Thanks

[youconnect]

I mean alone if the value 3 it's not present in id3 column with value 2. See in the cloumn id2 I have the 20 value with values 2,2,3 in the id3 column. In thise case I don't want count the 3 value.

In my case the expected value is 3 because it's count of lines 6,15 and 20

Thanks @jdbuchanan71 

[jdbuchanan71 · Accepted solution]

@youconnect 

The cleanest way I can think of doing this is as a calculated column added to your table.

Count = 
VAR RowIDTwo = 'Table'[id2]
VAR IDTwoCount = CALCULATE(COUNTROWS('Table'),ALL('Table'),'Table'[id2]=RowIDtwo)
RETURN IF ( 'Table'[id3] = 3 && IDTwoCount = 1, 1, BLANK())

[youconnect]

Worked like a charm.

Many Thanks @jdbuchanan71 

[jdbuchanan71]

Hello @youconnect 

What do you mean by "alone" in ID2?  Do you mean if ID2 is empty?  In your screen shot, which rows should be counted?