Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I want to create a table in Power BI like below :
Product Year Count
A 2020 100
B 2021 569
C 2021 99
The product is an input column which means I provide the name in the creation of the calculated table.
The Year is the group by column and the count is the a measure : counting the rows of the product A by Year
Solved! Go to Solution.
Hi @AmiraBedh ,
You could use SUMMARIZE() function.
https://docs.microsoft.com/en-us/dax/summarize-function-dax
Since the product is an input column, you will need to filter the table for each product before summarize it. Ie create multiple summarized table based on products then union the summarized tables.
For example:
new_table =
var product_a = SUMMARIZE(FILTER(Table,Conditon1),[Year]"product","A",COUNT([column]))
var product_b = SUMMARIZE(FILTER(Table,Conditon2),[Year]"product","B",COUNT([column]))
return
union(product_a,product_b)
If I misunderstood your meaning, please share some sample data and expected result.
Best Regards,
Jay
Hi @AmiraBedh ,
You could use SUMMARIZE() function.
https://docs.microsoft.com/en-us/dax/summarize-function-dax
Since the product is an input column, you will need to filter the table for each product before summarize it. Ie create multiple summarized table based on products then union the summarized tables.
For example:
new_table =
var product_a = SUMMARIZE(FILTER(Table,Conditon1),[Year]"product","A",COUNT([column]))
var product_b = SUMMARIZE(FILTER(Table,Conditon2),[Year]"product","B",COUNT([column]))
return
union(product_a,product_b)
If I misunderstood your meaning, please share some sample data and expected result.
Best Regards,
Jay
@AmiraBedh , Last two are easy, they can be driven using group by power query or summarize of DAX.
How do you want calculate the product, that you need to tell to suggest solutions
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |