Forum Discussion

Apple08's avatar
Apple08
Icon for Helper IV rankHelper IV
3 years ago
Solved

To group various data categories into slicer

Hi All   I have a table of data with various columns of data, e.g. Age, Name, Gender, Address etc.   I would like to extract some data into slicer selection for users to select when viewing data....
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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