Forum Discussion

daniel_digi's avatar
daniel_digi
New Member
5 years ago
Solved

Get Count of Rows for Table Visual Filtered by Measure

Hello,   I am having issues getting a row count of results based off a table being filtered by a measure.    Simplified current table layout is:  Table 1: Groups Table 2: Activities    Each g...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    daniel_digi ,  Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    I doubt anything I added to remove date filter.

    Add this to table as well Card and check

    countx(filter(summarize(Groups, Groups[group code],"_1",COUNTX(FILTER('Activties', Activties[Status] = "Completed"), 'Activties'[ActivityID]) + 0),[_1]>0),[group code])

amitchandak's avatar
amitchandak
Super User
5 years ago

daniel_digi ,  Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

I doubt anything I added to remove date filter.

Add this to table as well Card and check

countx(filter(summarize(Groups, Groups[group code],"_1",COUNTX(FILTER('Activties', Activties[Status] = "Completed"), 'Activties'[ActivityID]) + 0),[_1]>0),[group code])

daniel_digi's avatar
daniel_digi
New Member
5 years ago

amitchandak,

 

Your solution worked with 1 edit. I changed the > 0 to = 0.

 

Group Count = countx(filter(summarize(Groups, Groups[group code],"_1",COUNTX(FILTER('Activities', Activities[Status] = "Completed"), 'Activities'[ActivityID]) + 0),[_1]=0),[group code])

 

 This gave me the 169 result I expected, and changes correctly when I update the date slicer.

 

Thank you very much for your assitance!