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...
  • 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])