Forum Discussion
daniel_digi
5 years agoNew Member
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...
- 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])
Anonymous
5 years agoNot applicable
Hello! Is there a way I can apply this solution but filtering measures? I've tried replicating it but it doesn't work for me because I don't want to filter a table by a measure, but to filter a measure by another measure.