Creating conditional measure from different tables

Question

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 UseCaseI need to get the data from &lt;table1&gt;.&lt;visits&gt; when&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;table2&gt;.pos = 11 and&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;table3&gt;.RLP = "Par"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;table4&gt;.Proc = "ST" and "PMR"&nbsp;Could you please guide me best choice to either to create a DAX function or a new measure.Thank you&nbsp;K&nbsp;&nbsp;

amitchandak · Answer

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.

bairamsunil · Answer

Thank you Amit,&nbsp;These tables&nbsp; have a relation among them.

robinpatrick · Answer

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.

Forum Discussion

Creating conditional measure from different tables

3 Replies

Related content

Conditional formatting for difference between bars?

Create conditional measure

How to avoid people creating multiple times the same table in different workspaces

Different schema into different destination

Create a report per Worker ID with different datasets feeding different tablix