Forum Discussion
Get Count of Rows for Table Visual Filtered by Measure
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])
Unfortunately that does not return the expected result. If I add a count column to the table I can see my expected result is 169 however this returns 609.
While this does give me the count it's a bit ridiculous to have to include an entire column of 1s.
Additionally, the measure you provided does not update when I change the date period. Apologies I initially included the above screen shot indicating I was also filtering dates by a slicer but it doesn't appear to have been embedded correctly.
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])
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!