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...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi awhite2589 ,

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

    Best Regards

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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