Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Calculated columns without filters

Good afternoon

I'm starting in the world of Power BI t I have a colsquera about how to assemble a tables with calculated measurements or columns. I have several stores and I want to compare myself with market data. Below I show an example.

The data "Sales prov." corresponds to total sales, broken down by brand and province. Now I want to take out the data "Brand sales", that is, I filter only by brand, so that in the first and second line, which are stores of the same brand in different provinces, the same data is shown.

I hope you can help me or indicate a forum to share my query.

Thanks a lot.

9 Replies

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      3 years ago

      Thank you very much, but with this option I would show myself in the table or one data or another, but never both at the same time. I wanted to have a column with the sales data by brand and next to it another column with the sales data by brand and province. It's possible?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi @mmorales2022 ,

        I'm not clear about your requirement: have a column with the sales data by brand and next to it another column with the sales data by brand and province. Could you please provide some special examples to illustrate it? Thank you.

        Best Regards