Forum Discussion
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 ...
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
It seems that there are Type A Values in Table1, Type A Values and Type B Values in Table2, Type A Values in Table3. Where does the Type C Values come from?
Best Regards,
Herbert