Forum Discussion
remove duplicates names
This table will give you a distinct list of users who have at least one record where they are Foundation Ready according to what I think your rules are.
Let me know what you think
New Table = SUMMARIZE(
FILTER(
'Table',
'Table'[Office] IN {"Office 365","Office 2016"}
),
'Table'[User Name] ,
"Is-WindowsFoundationReady" , "Foundation Ready"
)Phil_Seamark nice touch with the IN operator! :smileyhappy:
so basically the above is equivalent to...
New Table ALT = SUMMARIZE ( FILTER ( 'Table', 'Table'[Office] = "Office 365" || 'Table'[Office] = "Office 2016" ), 'Table'[User Name], "Is-WindowsFoundationReady", "Foundation Ready" )I think the challenge there is that Bob will appear twice with two states (ready and not ready). Bit that is just my interpretation, which can be miles off :)
Hi Phil, when I tried to implement the new table it is giving me this error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
I see, thank you! Phil_Seamarkhow can I also provide users that are not foundation ready?
Phil_SeamarkJust out of curiosity, where can I find DAX complex examples to play? I have referred your answers to many threads, most of them out from DAX solutions. Can you please kindly provide some inputs, how I will be mastered with DAX.
Any reference links? Any Books?
Hi rocky09
I reckon the best source of complex examples to play with are here in the community. There is a good variety in the types of problems posted and remember not every accepted answer is necessarily the best. Take a few problems and look to see what other solutions you can come up with.
Other than that, I think Sean recommended the Definitive Guide to DAX the other day, and if he recommends it, it's probably pretty good.
Thank you.
