Forum Discussion

sheap069's avatar
sheap069
Icon for Helper III rankHelper III
5 years ago
Solved

Get Count of Rows for Table Visual

Hello,   I have a table of Group IDs that has columns from various tables. There are slicers on the page that affect this table visual, as well as measures that further filter the table.    I wan...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi sheap069 ,

     

    I'm not sure if I understand you correctly. Are you want to count a value based on the slicer on current page along with measures on an other page?

    If so you could try to create a measure like below.

    Measure 2 = CALCULATE(COUNT('Table'[id]),FILTER('Table',SELECTEDVALUE('Table'[year])='Table'[year]&&[Measure]=1))

    Here's my sample data and result.

    Measure = IF(SELECTEDVALUE('Table'[value])>30,1,0)

     

    Best Regards,

    Jay

     

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

what is the definition of what you are trying to count exactly.  What is contained in the table that you want?  Can you provide some examples of where the count is not working for you.  Visuals are useful, data even better.