Forum Discussion

timothystacy's avatar
timothystacy
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Create a new table from distinct values with conditions: Common Problem in Software Licensing area

Hi,   I would appreciate any help with the following:   Goal:  Create a table that identifies the following:   I have three fact tables that identifies software installed by a server name and a...
Tutorial Requests
  • timothystacy's avatar
    timothystacy
    9 years ago

    Thank you again.  This appears to work.  Funny, this was not what I was expecting.   The measure approach worked, I assume, because of the model I have in place plus each measure is evaluated on its own.  So, if I have 4 measures applied against the model, I will get the results specific to each measure.  At least, this is the way that it appears.

     

    This was very helpful.

     

    Tim

timothystacy's avatar
timothystacy
Icon for Advocate I rankAdvocate I
9 years ago

Thank you.  I applied the measure as you indicated below and it works.  Yet, adding the others to see if it give me all I need.  I am knew to this so it may take another day to provide additional feedback.

 

Tim

timothystacy's avatar
timothystacy
Icon for Advocate I rankAdvocate I
9 years ago

Thank you again.  This appears to work.  Funny, this was not what I was expecting.   The measure approach worked, I assume, because of the model I have in place plus each measure is evaluated on its own.  So, if I have 4 measures applied against the model, I will get the results specific to each measure.  At least, this is the way that it appears.

 

This was very helpful.

 

Tim