Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am facing one scenario when developing user requirment which tracks
I need to capture 3 types of counts which will tell the Users about the status of bugs for every month.
1. [Closed Bugs this Month]
2. [Newly Added Bugs this Month]
3. [Total Active Bugs Till Date]
[closed bugs count] : it will tell about the count of bugs which are closed in time frame selected.
[Newly added Bugs Count]: it will tell the count of bugs that are added in time frame selected.
[Active Bugs]: Actuve bugs seen at a pirticular Date is [Bugs Added till that Date]-[Closed Bugs Till that Date]
My output should be some thing like it should show stacked bar graph for last 3 months.
I have Implemented Logic Upto getting the [active], [Closed],[Newly Active]. I am getting [Newly Active],[Closed] from Dataset Directly just Created a just sum measure for them. But For [Active] I have created a Measure which will calculate it by using concept of Running totals.
Here My problem is I am not able to show the correct [active count] for last 3 months. if I use Relative Date filter in Filter section. I am not getting [Active] correct. May be reason is if data is filtered to show onlt last 3 months. Example: sep,aug,jul. it will not show data before those dates. before July. if 5 bugs are logged in january and no bug is closed after that. [Active count] should show still 5 for all the months in future. If I filter last 3 months; as there is no bugs logged in after january in this example I am not getting no data for selected 3 months.
Can anyone help me on this how can we acheive a filter which calculate the [active] for the last 3 months even the actual data is not present in selected filter. Measure should be calculated irrespective of date filter for every month. but only the Latest 3 months should be shown in visual.
1a.( Expected overall graph)
1b. (Expected pirticualar Graph for better understanding): Here
jul : 11 bugs are newly added. so Newly active = 11 ,Closed = 0, Active = 11-0 =11
aug: 1 bug newly added. so newly added = 1, closed=0, Active = (11+1) - (0+0) = 12.
sep: 0 bugs added or closed so Newly added =0 ,closed=0 active = (11+1+0) - (0+0+0) =12
1c. (result I am getting when I am trying to filter last 3 months of data by using relative date in filter section. (it will change to Aug,sep,oct in month of october) in below case I need to get 12 in september month but I am getting Blank.
Solved! Go to Solution.
got the solution.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |