Forum Discussion
Trending Graph - Help!
@Stephen239
Check pbix if necessary, here are the 2 measurements with your sample data.All issues = CALCULATE(COUNT('Report Content'[Id]),FILTER(ALLSELECTED('Report Content'),[Created on]<=MAX([Created on]))) Closed issues = CALCULATE(COUNT([Id]),FILTER(ALLSELECTED('Report Content'),[Created on]<=MAX([Created on]) && [Status]="CLOSED"))Paul Zheng _ Community Support Team
If this post helps, please accept it as the solution to help the other members find it faster.
Super UserAnonymous , looking at data not able to find a way to know both open and close dates. If you have that we can follow the current employee approach or HR : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi, thanks for your response. See link below to data in its native format.
@Stephen239
Check pbix if necessary, here are the 2 measurements with your sample data.All issues = CALCULATE(COUNT('Report Content'[Id]),FILTER(ALLSELECTED('Report Content'),[Created on]<=MAX([Created on]))) Closed issues = CALCULATE(COUNT([Id]),FILTER(ALLSELECTED('Report Content'),[Created on]<=MAX([Created on]) && [Status]="CLOSED"))Paul Zheng _ Community Support Team
If this post helps, please accept it as the solution to help the other members find it faster.Thank you very much, this is perfect!