Forum Discussion

MSFTServices's avatar
MSFTServices
New Member
5 years ago

LookUpvalue Multiple values Count

Hello Community,

 

I have 2 tables, {Documents, Progress} wants to calculate Doc_Category Count and Value for specific Date. something like based on Received Date in Progress table.


ReceivedDate          Doc_Category        Count   

1/1/2010                 Admin                    20

1/2/2010                 Admin                    2

1/3/2010                 Admin                    3

 

As Doc_Category Column contains multiple Categories might 20 or so then below mentioned DAX function gives me 20 Doc_Category in one Column too confusing data comes.
 
LOOKUPVALUE(Documents[Doc_Category],Documents[Date].[Date],Progress[Date].[Date]) but it gives me 
(A table of multiple values was supplied where a single value was expected.)
 
So using this but still not giving desired
CONCATENATEX(CALCULATETABLE(VALUES(Documents[Doc_Category] )),[Doc_Category],",")
 


For reference, kindly find the attached PBIX file. CommunityFile 


While search i could find following names...
can you guys give a hint please , Need your expert advise please. Thank You
Need Help

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Your question is not clear at all.  Please show the expected result based on the sample data that you have shared.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi MSFTServices ,

    Which date column in the "Documents" table do you use to create a LOOKUPVALUE() formula? Received, Reviewed or approved?

     

    Could you please share the expected result to have a clear understanding of your question? I can do some tests for you.

     

    Best Regards,

    Yuna

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi MSFTServices ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

     

    Best Regards,

    Yuna