Creating conditional measure from different tables

[bairamsunil]

Hello Group,

I am very new to PowerBI, trying to migrate some of old excel reports into Power BI, I am stuck with one of the conditional data pull.

Here is the UseCase

I need to get the data from <table1>.<visits> when

               <table2>.pos = 11 and 

               <table3>.RLP = "Par"

               <table4>.Proc = "ST" and "PMR"

Could you please guide me best choice to either to create a DAX function or a new measure.

Thank you 

K

[RobinPatrick]

Open SQL Server Management Studio. On the Tools menu, click Options. In the navigation pane of the Options window, click Designers. Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

[bairamsunil]

Thank you Amit, 

These tables  have a relation among them.

[amitchandak]

@bairamsunil , are these tables have any relationship, what is the data model?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.