Forum Discussion

badgerr11's avatar
badgerr11
Regular Visitor
8 years ago

Duplicating and filtering columns

I'm new to Power BI and still trying to wrap my head around it. I have a column that I'd like to duplicate and keep in the same pbix. This column holds values indicating if an account is paid, free, ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can you post sample data or sample PBI file with expected outcome.

 

Thanks
Raj

badgerr11's avatar
badgerr11
Regular Visitor
8 years ago

Here's an image, wasn't able to upload a pbix. Thanks

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Oh, got it . You are doing this in Power Query and i was talking abt DAX. Obviously, if you apply filter in one column the other columns also will have the same value as its simply the copy of the original column.

     

    If you want to have do this only in Power Query - you need to copy the source table and have 3 different sources and apply the filter in each table . So, you will have a Paid Table, Free Table and Neither Table.

     

    If you want to handle this in DAX calculation , then you can use the ALL() and FILTER()  & CALCULATE() as needed for your requirements.

     

    Hope this helps.

     

    Thanks

    Raj

    • badgerr11's avatar
      badgerr11
      Regular Visitor
      8 years ago

      Thanks Raj! I'll work  on figuring itout