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 , Assumed two table are connected and the group has an ID column it can be a name too

 

Try

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