![]() If no slicer value is selected show all rows.Ĭheck = if(PATHCONTAINS(,min(Data)),1, Now you can create a DAX measure so you can determine whether to show the row or not.Īs the LIST is a concatenated string with a pipe| separator we can use PATHCONTAINS expression. If(SelectedValues = "My Stuff",PersonSpecific, ![]() Var PersonSpecific = LOOKUPVALUE(Map,Map,USERPRINCIPALNAME()) InterestList = var SelectedValues = CONCATENATEX(Values('InterestsUnion'),'InterestsUnion',"|") Return either the selected value(s) OR the interest value from the mapping table. Now you can create a DAX expression which returns a single text value which is a concatenated string containing all the selected values from the slicer. InterestsUnion = UNION(DISTINCT(SELECTCOLUMNS(Data,"interest",Data)),) In this example my raw data has a Team column and the mapping table maps individuals to teams ‘of interest’ It’s a UNION of the distinct values of the column of interest (in this case it's the column from my Data table) and a ’My Stuff’ entry. You can select single values or multiple values if concatenated with a pipe.Ĭreate a DAX table which becomes the slicer value. #MYSTUFF PRO REVIEW PLUS#Set up a ‘mapping table’ to include the email address of the user plus an ‘interest’ column or the ‘thing’ that you want to slice/filter…. Supports Camera+ for image editing and photo taking.I've managed to sort out a fairly straightforward approach. ![]() ![]() Problems can't be fixed if they are not reported. NOTE: If you have any issues please contact support. Please visit to see additional information, tutorials, FAQs, and contact information for MyStuff2 Pro. You can also passcode protect individual categories. Protect access to your data with a passcode. Shows item count, totals, and averages of your data. See a summary of the item list you are viewing. Apply colors to categories, actions, or individual items to make them stand out. Other users of MyStuff2 Pro can import your shared data directly simply by opening the email attachment.Ĭustomize item lists to display exactly the data you want to see. Email lists to co-workers or friends and family. Store up to 40 images for each of your items.Īdd file attachments to your items.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |