Forum Discussion
Solved
Create table containing only rows with minimum values from every category
Hello again. I tried to create a summarized table without some rows. This is the data table: I want to only show rows containing minimum values from specific category. This is the desire...
Zyg_D , you can create a table like
summarize(Table, Table[Category], "Value", min(Table[Value]), "Value2", max(Table[Value2]))
or can use a measure like this with Category in a visual min(Table[Value]) and max(Table[Value2])
Zyg_D because you are also summarizing on value2 column and combination of category and value2 is unique in all 4 rows and that's why you are getting all rows.
Do you need value2 in summarize table?
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡