Forum Discussion

timstacy1's avatar
timstacy1
Frequent Visitor
9 years ago
Solved

Find the Distinct Value based on other columns

Hi,   I want to create a dax formula that will produce a list of unique guest values from Column A, and find only the distinct value in column B (Host) based on the latest date.  The final report w...
Show and Tell
timstacy1's avatar
timstacy1
Frequent Visitor
9 years ago

Hello,

 

Thank you.  The measures generated the following erros:

 

MdxScript(Model)(10,49) Calculation error in measure 'allguests'[hostlatestreport]:  a table ofmultiple values was supplier where a single value was expected.

 

I have a long list of guest and host entries.  Could this be the source of the error?

 

Thank you,

 

Tim

 

 

timstacy1's avatar
timstacy1
Frequent Visitor
9 years ago

You are correct.  I am only interested in a unique host for every unique guest, using the latest date as the determining factor.  My apologies for the flawed table but glad you figured it out.  I applied the measure and it worked!  I can't believe it.  I can't tell you what a help this is.   Now, I need to figure out why it works.  And, due to the size of the file I am working with, I run out of memory.  

 

Thank you again!

 

Tim

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi timstacy1,

     

    Glad to help! Could you accept helpful replies as solution to close this thread? :smileyhappy:

     

    Regards