Answer depending on multiple queries?

[Anonymous]

Hello!

Was hoping to get some answer as below

Calculate the conversion rate based on a row number (row number being 1) from 3 different tables - all of which have a row number as 1

Proposed NCR (Value 1) = CALCULATE(IFERROR([NCR]*(1+[ELasticity -0.03 TO 0])^(('Discount'[Parameter Value])*100),0))

I was thinking maybe an OR statement would work but this doesnt seem to be the case.

I would like this value to be produced if the row number (query 1) = 1 OR row number (query 2) = 1 OR row number (query 3) = 1

Im more than happy to discuss in detail if needed over dm!

GC

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523