calculate sum of categories and return the minimum of it

[elaj]

Hi,

i have data like this: 

the measure is a counta measure.. so it counts the occurrences of cat by month and cat itself.

and now want to have a new table which shows me the minimum (sum) value of all categories per month.

it would be feb = 3, jan = 2, mar = 1.

i really dont know how to do it.

someone has an idea?

pbix

thanks for help

[iXpert_info]

Hello @elaj 

Just unpivot your above table and that way your months will become attributes and counts will become value
and create calculated column 
MinCount = Calculate(table[Value]), filter(table, table[month]=Earlier(table[Month])))
iXpert_Solution 

Best Regards
Jay Patel

Did I answer your question? Please mark my answer as solution

[HotChilli · Accepted solution]

A measure like this :

MeasureX = MINX(Tabelle, [count])

Put it in a table with 'wave'