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