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 ...
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

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

That is indeed what I need. I share my data source table with you.

The data I want to classify correspond to the measure Mattriculations = CALCULATE(COUNT('TOTAL REGISTRATIONS'[Rack]), 'TOTAL REGISTRATIONS'[New "N" - Used "U"] = "N" )

I have created the table "Concession" and in it I have entered the column Sales prov. (sales by brand and province, Sales prov. = CALCULATE(COUNT('TOTAL REGISTRATIONS'[Rack]),'TOTAL REGISTRATIONS'[New "N" - Used "U"] = "N" ) ), but now I do not know how to put a new columa with sales only by brand. The table is as follows:

Both tables are related by the field Concession (oriegen table) - Concession code (table above)

I don't mind doing it with measurements instead of calculated columns if it were a better solution.

Thanks a lot.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    I show again the source table, that the previous one had errors:

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      3 years ago

      Good afternoon

      I show a new example of what I am looking for so that it is better understood. Starting from the following table:

      What I want to get is a table that shows me the registrations by brand, by province and by brand / province. The result would be this:

      How could you propose the measures in Power BI to obtain such a table?

      Thanks again.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi mmorales2022 ,

        Could you please provide the sample data with Text format? You can paste it in your post directly. And could you please provide your expected result with calculation logic and special examples?  It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

        How to upload PBI in Community

         

        Do you want to get the count of Rack group by Brand, Province and (Brand&Province) separately? If yes, you can refer the following links to get it.

        DAX method:

        Group BY and COUNT

        Power Query method:

        Grouping or summarizing rows

        Best Regards