Forum Discussion
GitHub App Issues data is inaccurate
Hey Everyone, I connected my team's GitHub Repository to the GitHub PowerBI app in order to get some metrics together on how our Issue Management is going. I followed this guide: Connect to GitHu...
Looks like the count of open issues is actually the count of labels on open issues.
To confirm, add a drill-through and download to Excel and see the duplicated rows for every issue, and each duplicate row shows a different label attached to that issue.
I'm not sure how to work around this, it's blocking me from proceeding with using Power BI and the GitHub connector.
A bit late but perhaps still useful?
You can add a new metric using the information in this post: https://community.powerbi.com/t5/Desktop/how-to-count-distinct-values-in-a-column/td-p/93120
Real Open Pull Requests = CALCULATE(DISTINCTCOUNT('Pull requests'[number]), 'Pull requests'[state] = "open")