Forum Discussion
Trending Graph - Help!
Hi, first time poster - I have given up after 8 hours of trial and error and youtube tutorials. Maybe I'm not cut from the right cloth 😞 Basically, I have some data (attached) which I'd like to...
@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.
@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!