Forum Discussion

awhite2589's avatar
awhite2589
Frequent Visitor
5 years ago
Solved

DAX Filters

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

Need Help
Tutorial Requests

5 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    HI awhite2589 

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

    regards

    Phil

  • awhite2589's avatar
    awhite2589
    Frequent Visitor
    5 years ago

    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

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi awhite2589 ,

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

      Best Regards

      • awhite2589's avatar
        awhite2589
        Frequent Visitor
        5 years ago

        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.