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

daniel_digi's avatar
daniel_digi
New Member
5 years ago

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.  

  • 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!