Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
5 years ago
Solved

Countif equivalent in Power BI

Hello.  I have a column in TableA that is a concatenate of two fields:  ProductID and CountryID.  In TableB, I have another column that is also a concatenate of ProductID and CountryID.  I am looking...
Need Help
  • Unicorn_Tech's avatar
    Unicorn_Tech
    5 years ago

    I ended up doing this, but I feel it's a bit convulted.  I couldn't get the above solutions to work.

    Match record = if(ISBLANK(lookupvalue(TableB[check], TableB[check], TableA[Check])),"No record", "Record")
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Unicorn_Tech 

An example based on sample data with the expected result would help understanding the requirement. Try this:

1. Place TableA[Column1] in a table visual

2. Create this measure and palce it in the visual:

Measure =
IF (
    CALCULATE (
        COUNT ( TableB[Column1] ),
        TREATAS ( SELECTEDVALUE ( TableA[Column1] ), TableB[Column1] )
    ) > 0,
    TRUE (),
    FALSE ()
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers