Solved: Countrows IF - Microsoft Power BI Community
community.powerbi.com › t5 › DesktopAug 29, 2019 · @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 ()) View solution in original post Message 4 of 5 496 Views 1 Reply