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

Bitwize_PowerBI's avatar
Bitwize_PowerBI
Icon for Advocate IV rankAdvocate IV
9 years ago

Hi Tim,

 

What if you created a measure that returns a 1 only if 'Tool A' = 1:

Only Tool A = IF([Tool A] = 1 && ISBLANK([Tool B]) && ISBLANK([Tool C]);1;blank())

 

For your other logic you can create seperate measures.

 

Regards,

Dries

  • 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