Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hopp
New Member

Calculate value for each date based on filters

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:

DateTimeEstimatedIssueCountIssueCountEpicName
12.02.2022 00:0004Home Screen
12.02.2022 00:00020Subscription Screen
06.03.2022 00:00410Home Screen
06.03.2022 00:002133Subscription Screen
10.03.2022 00:00410Home Screen
10.03.2022 00:002541Subscription Screen
14.03.2022 00:0048Home Screen
14.03.2022 00:002534Subscription Screen
22.03.2022 00:0079Home Screen
22.03.2022 00:003037Subscription 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

hopp_0-1648219181224.png

DateTimeEstimatedIssueCountIssueCountEstimated Count
12.02.2022 00:00040%
06.03.2022 00:0041040%
10.03.2022 00:0041040%
14.03.2022 00:004850%
22.03.2022 00:007978%


After selecting Epic Subscription Screen i'd like to see

hopp_1-1648219197834.png

DateTimeEstimatedIssueCountIssueCountEstimated Count
12.02.2022 00:000200%
06.03.2022 00:00213364%
10.03.2022 00:00254161%
14.03.2022 00:00253474%
22.03.2022 00:00303781%

After selecting both I'd like to see

hopp_2-1648219218097.png

DateTimeEstimatedIssueCountIssueCountEstimated Count
12.02.2022 00:000240%
06.03.2022 00:00254358%
10.03.2022 00:00295157%
14.03.2022 00:00294269%
22.03.2022 00:003746

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 !

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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

View solution in original post

2 REPLIES 2
johnt75
Super User
Super User

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.