Forum Discussion

igaca's avatar
igaca
Helper III
9 years ago

ADDCOLUMNS and actual values return (e.g. text string)

  Greetings:   I have a question for the Community as follows:   Background:   I used an INTERSECT() to generate a single column table that is a return of distinct values of "Type A" that are ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
igaca's avatar
igaca
Helper III
9 years ago

Works like a charm and more importanly, I think I understand your approach - bravo and thank you Maxim!

 

Now let me see if I can complicate things a bit  :)  :

 

Should there be a need to add another column of values "Type C" which match the returned column of values "Type B" called out in the SUMMARIZE() and filtered in the initial CALCULATETABLE() filter argument, how might one go about that one?

 

I'm working on it now and will update the post if I resolve the question but I would love to see someone else's (likely better) approach.

 

Thanks again!

 

Igor

hohlick's avatar
hohlick
Continued Contributor
9 years ago
What if you just add column C in Summarize? Do not sure in what table it is?
  • igaca's avatar
    igaca
    Helper III
    9 years ago

    The issue is that SUMMARIZE requires the initial <table> argument and there is no single table within the entire model that contains / correlates all values types ("A" --> "B" --> "C").  The other issue is the relationship type/flow from tables.  For example, the table referenced within SUMMARIZE is table 3 - "T3 EDL to DWGS"- and value Type "C" columns are located in table 7 ("T7 EDL to NEEDS Table") which correlates Type "B" and "C".  I've tried to use RELATEDTABLE() but it will not work due to multiple changes in table relationships (many-to-one, then one-to-many, then many-to-one, and lastly one-to-many again as T7 is reached) 

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    igaca

     

    I’m not quite clear about your current problem here. Could you please give some table samples with some data in them, and describe the expected output?

     

    Best Regards,

    Herbert