Forum Discussion

sheap069's avatar
sheap069
Helper 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

     

Anonymous's avatar
Anonymous
Not applicable
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