IF+COUNTIF in POWERBI

Question

Actually, I have met a problem about how to filter the special column by criterias.In Exccel,if+Countifs is easy.City&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Transportation&nbsp; &nbsp; &nbsp; &nbsp;Metro?Beijing&nbsp; &nbsp; &nbsp; &nbsp; Air&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;YesBeijing&nbsp; &nbsp; &nbsp; &nbsp; Metro&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; YesBeijing&nbsp; &nbsp; &nbsp; &nbsp; Train&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; YesShanghai&nbsp; &nbsp; Air&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;YesShanghai&nbsp; &nbsp; Metro&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; YesShanghai&nbsp; &nbsp; Train&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; YesNanchang&nbsp; &nbsp;Air&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NoNanchang&nbsp; &nbsp;Train&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Noso my question is : how to get column"Metro?" by DAX functions?

zubair_muhammad · Answer

Nightlight&nbsp;Hi&nbsp;You can use this calculated column in Power BI&nbsp;Column =
CONTAINS (
    FILTER ( Table1, Table1[City] = EARLIER ( Table1[City] ) ),
    [Transportation], "Metro"
)

v-juanli-msft · Answer

Hi&nbsp;Nightlight
As tested, Zubair_Muhammad's formula can get the expected results as the picture you provided.

&nbsp;
Best regards
Maggie

Forum Discussion

IF+COUNTIF in POWERBI

2 Replies

Related content

IF(COUNTIF)

POWERBI Subscription

PowerBI Workspaces

IF(CountIFS Greater than + other criteria

iframe powerbi