Forum Discussion

Asha_2021's avatar
Asha_2021
Frequent Visitor
4 years ago

How to fix lookup table to fetch data only from one table, when four tables are connecte

S1 value should come only from T1, not from T3Pls help me to fetch value only from one table, rather the S1 is present in two two tables(T1 & T3) but I don't want it to fetch from T3. Anonymous Greg_Deckler

Need Help

3 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Asha_2021 

     

    What is your expected output? When you are creating a visual, if you select columns from Lookuptable and T1 table, you will not see data from T3 table in the visual. If you want to add a column or a measure or something else, could you provide some sample data and expected result to help us understand it better?

     

    Best Regards,
    Community Support Team _ Jing

    • Asha_2021's avatar
      Asha_2021
      Frequent Visitor
      4 years ago

      Hi Jing,

       

      Please help me, I am stuck and can't move ahead.

      this is my measure:

      reqcount2 = IF(SELECTEDVALUE('AWS Sum'[COST])="Public Transit",[PublictransitawsReq],IF(SELECTEDVALUE('AWS Sum'[COST])="Forward Geocoder API 6.2",[Forward Geocoder API6.2_AriaReq],IF(SELECTEDVALUE('AWS Sum'[COST])="Reverse Geocoder API 6.2",[Reverse Geocoder API 6.2_AriaReq],CALCULATE(SWITCH(TRUE(),SELECTEDVALUE('AWS Sum'[COST]) in VALUES(Transactions[Odin Application Name]),sum(Transactions[req_count]),SELECTEDVALUE('AWS Sum'[COST]) in VALUES(Aria_bulk[Responsible]),SUM(Aria_bulk[count]),SELECTEDVALUE('AWS Sum'[COST]) in VALUES(Aria_extendedbulk[Application]),SUM(Aria_extendedbulk[recorded_units]),SUM('AWSreq-splunk'[Value]))))
       
       
      Problem here is if I am looking for value of an application, then it first search in 
      (Transactions) table and then  moves to 
      (Aria_bulk) table, 
      what I am looking here is for eg: if ABC is an application name and if for that the value should be fetched only from (Transactions) table... it should not look in
      Aria_bulk table if the value is not found in (TRansactions) table:
      Because currently , it is fetching value from Aria bulk if not found in TRansaction table:

      And it's a vice versa thing, for eg in the image For fleet connectivity Extension, it is displaying value.. but Ideally it should be blank, becuase for this application the value should be fetched only from (Transactions) table, but it is fetching from Aria_ bulk table, because the value is not there in Transcation table.

      what changes is required to this expression.