DAX Filters

[awhite2589]

Hello!

I am new to PBI and have a question regarding DAX filters.

Let me lay the situation out. I have a column "Material Descriptions" and a column "Billing Doc #. There are multiple "Material Descriptions" for each "Billing Doc #". I am attempting to single out certain "Material Descriptions", find there corresponding "Billing Doc #'s", and then loop around and see what Materials are sold with the initial Material description search.

I created this calculated column:

= if( Table[Material Description] = "Material" , Table[Billing Doc #], Blank () )

This captures all of the billing Doc #'s I need, but when I use this as a slicer it only shows the original "Material Description" that I searched.

Any help would be appreciated.

Thanks!
WA

[awhite2589]

Thank you for the quick reply!

Ex. I would like to identify that Orange has a Billing doc # of 4 and 3. Then, back track and find that Purple was sold in the same bill.

I hope this clarifies things.

Thank you!

Material Description   Billing Doc #
Blue                             1
Red                              2
Green                          2
Orange                       4
Purple                         3
Yellow                        1
Yellow                         2
Orange                        3

[v-yiruan-msft · Accepted solution]

Hi @awhite2589 ,

I created a sample pbix file(see attachment), please check whether that is what you want.

Best Regards

[awhite2589]

Could you briefly explain why you used the "In Allselected" Operator in line 8 of the Flag Meaure. From my understanding, the original ALLSelect operator removes all filters for the designated table. In this case, it would be for the "Table", not the "Material Table". Can you explain this? Thank you for your help.

[v-yiruan-msft]

Hi @awhite2589 ,

As you can check my sample pbix file, I created a slicer used the field from dimension table Material. I get all of selected matrials from slicer selections by useing "in allselected(Material[Material description])". You can watch the following video to get better understanding about how to get multiple selections from slicer.

Get selected or multiple values from slicers using DAX

Best Regards

[PhilipTreacy]

HI @awhite2589 

Please supply some sample data as text or file.  Hard to get my head around your data without seeing it.

regards

Phil