Calculated columns without filters

[Syndicate_Admin]

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.

[Anonymous]

Hi @mmorales2022 ,

You can create a slicer and put Brand field onto the slicer just as below screenshot. Please find the details in the attachment.

Create slicers to apply the data

Best Regards

[Syndicate_Admin]

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]

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]

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]

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

[Syndicate_Admin]

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]

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

[Syndicate_Admin]

Thank you very much, indeed what I need is to get the count by brand, province and (brand and province) separately and include them in a table.

I can not apply the enlces that you share to my problem.

Then I put link to my pbix:

https://grupotecsa-my.sharepoint.com/:u:/g/personal/mercedes_morales_grupo-tecsa_com/EafVIZjyo3BCrzX...

I have managed to get the 3 data in a table, but coming from calculated columns, the slicer does not work for me to select the dates.

How do I make the segmetacion work?

Thanks again.

[Syndicate_Admin]

Neither the DAX Method nor the Power Query Method have served me, any alternative?

Thanks in advance.