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

Use ALL () function to ignore the filter on the base column.

 

New_Column= ALL( Table1[Column1])

 

Hope this helps.

 

Thanks

Raj

  • badgerr11's avatar
    badgerr11
    Regular Visitor
    8 years ago

    Thanks for the reply and help, I appreicaite it! Unfortunately Power BI throws an "A table of multiple values was supplied where a single value was expected." message. Even when I filter for just one value (0,1, 99) before creating the new column.

    • 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