Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count If Contain X, Y, Z

Hi All,

Can anyone help this dummy user with the problem below?

Thank you in advance,

Rui Luis

 

 

 

1 Reply

  • Hi,

    In the Query Editor, right click on the OfferIds column and select Split column > By rows.  Create a relationship from the Offerids column of Table B to the Offer ID column of Table A.  Drag both column from Table A to your visual.  Write this measure

    =counta('Table B'[Offerids])

    Hope this helps.