Forum Discussion
youconnect
Helper I
Helper ICountrows IF
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. ...
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())
youconnectHelper I
Helper II 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
Super User
Super UserThe 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