Forum Discussion

youconnect's avatar
youconnect
Icon for Helper I rankHelper I
7 years ago
Solved

Countrows 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.  ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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())

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

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?