Calculate value for each date based on filters

hopp — Fri, 25 Mar 2022 14:51:18 GMT

I have an export from JIRA where for each date I have epic name, number of issues and number of issues with time estimate.

I'd like to create visualisation of percentage of estimated issues per date based on selected epics. I can selected multiple epics and I'd like to see cumulatively calculated values for each date.

If it matters, as a result I'd like to see a line.

Sample Data:

Date	TimeEstimatedIssueCount	IssueCount	EpicName
12.02.2022 00:00	0	4	Home Screen
12.02.2022 00:00	0	20	Subscription Screen
06.03.2022 00:00	4	10	Home Screen
06.03.2022 00:00	21	33	Subscription Screen
10.03.2022 00:00	4	10	Home Screen
10.03.2022 00:00	25	41	Subscription Screen
14.03.2022 00:00	4	8	Home Screen
14.03.2022 00:00	25	34	Subscription Screen
22.03.2022 00:00	7	9	Home Screen
22.03.2022 00:00	30	37	Subscription Screen

Of course, I have more Epics than two and broader date range in reality.

After selecting Epic Home Screen I'd like to achieve outcome

Date	TimeEstimatedIssueCount	IssueCount	Estimated Count
12.02.2022 00:00	0	4	0%
06.03.2022 00:00	4	10	40%
10.03.2022 00:00	4	10	40%
14.03.2022 00:00	4	8	50%
22.03.2022 00:00	7	9	78%

After selecting Epic Subscription Screen i'd like to see

Date	TimeEstimatedIssueCount	IssueCount	Estimated Count
12.02.2022 00:00	0	20	0%
06.03.2022 00:00	21	33	64%
10.03.2022 00:00	25	41	61%
14.03.2022 00:00	25	34	74%
22.03.2022 00:00	30	37	81%

After selecting both I'd like to see

Date	TimeEstimatedIssueCount	IssueCount	Estimated Count
12.02.2022 00:00	0	24	0%
06.03.2022 00:00	25	43	58%
10.03.2022 00:00	29	51	57%
14.03.2022 00:00	29	42	69%
22.03.2022 00:00	37	46	80%

As you can see. In last graph values are added up for each date and selected epics. Result is calculated as division of both values.

I can do custom column, but it doesn't respect filter. As I understand it, measure is one number for whole dataset.
Thanks !

Re: Calculate value for each date based on filters

tamerj1 — Fri, 25 Mar 2022 15:46:06 GMT

Hello hopp

Not sure if I missing something. From your description you only need to have a simple measure

Estimated Count = DIVIDE ( MAX ( Table[TimeEstimatedIssueCount] ), MAX ( Table[IssueCount] ), 0 )

it should work as you wish

Re: Calculate value for each date based on filters

johnt75 — Fri, 25 Mar 2022 15:28:35 GMT

Estimated Count % = DIVIDE( SUM('Table'[TimeEstimatedIssueCount]), SUM('Table'[IssueCount]))

topic Re: Calculate value for each date based on filters in DAX Commands and Tips

Calculate value for each date based on filters

Re: Calculate value for each date based on filters

Re: Calculate value for each date based on filters