Forum Discussion
Helper IVTo group various data categories into slicer
Hi Apple08 ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a measure.
count = COUNTROWS(FILTER(ALL('Table'),'Table'[year]=MAX('Table'[year])) )(3) Then the result is as follows.
If this is different from your expected result, please create a new post for a detailed description of your new problem and expected result.
To make the post more relevant, please mark the correct response to the original problem of the post as the solution, with thanks in advance.Best Regards,
Neeko Tang
Helper IVMany thanks Neeko. Please I would like to count how many items in different columns based on years, please could you show me how to do it?
Many thanks.
Hi Apple08 ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a measure.
count = COUNTROWS(FILTER(ALL('Table'),'Table'[year]=MAX('Table'[year])) )
(3) Then the result is as follows.
If this is different from your expected result, please create a new post for a detailed description of your new problem and expected result.
To make the post more relevant, please mark the correct response to the original problem of the post as the solution, with thanks in advance.
Best Regards,
Neeko Tang