Forum Discussion
Solved
Summarize Table with two categories
Hello community! Imagine that you have a table with a list of products and each product is given a specific rating (A,B, and C). These products are sold every year (2020 to 2022) and I want to se...
Hey Kuri_191 ,
Taking your data sample below + DAX to create a table:
Table_3_v2 = ADDCOLUMNS ( SUMMARIZE ( Table_3, Table_3[Rating], 'Date'[Year] ), "Weight", DIVIDE ( CALCULATE ( COUNT ( Table_3[concat1_ (period/rate)] ) ), CALCULATE ( COUNT ( Table_3[concat1_ (period/rate)] ), ALL ( Table_3[Rating] ) ) ) )
FreemanZ
Super User
Super Userhow does your dataset look like?
Hello Freemanz,
Thanks for the reply.
Here a small portion of the dataset. From all the 4 fields, only the Year is not from the same table. Year is on a dates table, but is connected with the table from the remaining 3 fields.
concat1_ (period/rate) Rating Year ID 01/01/2020A A 2020 6171 01/01/2020A A 2020 6188 01/01/2020A A 2020 6279 01/01/2020A A 2020 6332 01/01/2020A A 2020 6338 01/01/2020A A 2020 6398 01/01/2020B B 2020 6194 01/01/2020B B 2020 6195 01/01/2020B B 2020 6214 01/01/2020B B 2020 6222 01/01/2020B B 2020 6224 01/01/2020B B 2020 6234 01/01/2020B B 2020 6237 01/01/2020B B 2020 6242 01/01/2020B B 2020 6260 01/01/2020B B 2020 6261 01/01/2020B B 2020 6267 01/01/2020B B 2020 6273 01/01/2020C C 2020 6178 01/01/2020C C 2020 6183 01/01/2021A A 2021 13827 01/01/2021A A 2021 13847 01/01/2021A A 2021 13848 01/01/2021A A 2021 13891 01/01/2021B B 2021 13966 01/01/2021B B 2021 13989 01/01/2021C C 2021 13833 01/01/2021C C 2021 13909 01/01/2021C C 2021 13921 01/01/2021C C 2021 14042 01/01/2021C C 2021 14135 01/01/2021C C 2021 14159 01/01/2021C C 2021 14169 01/01/2021C C 2021 14195 01/01/2021C C 2021 14224 01/01/2021C C 2021 14288
