cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RMSLUIS
Frequent Visitor

Count If Contain X, Y, Z

Hi All,

Can anyone help this dummy user with the problem below?

Thank you in advance,

Rui Luis

 

RMSLUIS_0-1596843559302.png

 

 

1 REPLY 1
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!