Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

create filter for two columns under different table

This message is in reference to below: https://community.powerbi.com/t5/Power-Query/Creating-dynamic-slicer-for-column-month-in-a-table/m-p/1021791#M34739

 

I found that the problem is because the " supplemnetal part#budget" from the budget table is repeating the part number for all the supplemental part # (from order line). There are 9 part so the result I am getting is 9 X 9. For each only one in correct , where the part number is same - highlighted below. 

 To solve this, I want to check ifwe can create a measure which can check this and we can use it as a slicer. ... 

Excel if formuala :  = IF(supplemental Part# budget = Supplenetal part#, 1,2)

Thanks in advance for help.

 

 

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    Hi Anonymous ,

     

    Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.