How to calculate the total Open tickets per day

[Anonymous]

Hi Team,

I have requirement like

Date                          Opend measure                     Closed measure                                Open measure

6/12/2020                  10                                                     7                                                    3

6/13/2020                   15                                                     8                                                  10

6/14/ 2020                  5                                                      5                                                   10

6/15/2020                 20                                                      26                                                  9

how to Achive the above  open measure throurgh dax (open measure = previous day open+ today opend-Closed) 

i have opend measure and closed measure like

Date                    opened Measure                           Closed Measure

6/12/2020               10                                               7

6/13/2020               15                                                8

6/14/2020                5                                                5

6/15/2020              20                                             26

Can any one help me 

[amitchandak]

@Anonymous , refer this blog on similar topics

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Anonymous]

Hi Amit

That link is not releavent for my requirement .

I have a meausre called opened and closed measures. but i need to calculate the total opening tickets for the day.

can you please help me on this

Thanks!!

Nagaraju

[tex628]

Total open tickets = 
VAR maxDate = MAX(Calendar[Date])
Return
Calculate([Open] - [Closed];ALLSELECTED(calendar);Calendar[Date]<=maxDate)

[Anonymous]

Hi tex68

Thanks!! For the replay

But the given formula or measure is not working properly

Thanks!!

Nagaraju

[tex628]

You have to provide more information. Images or more specifics regarding the outcome and the intended outcome. 

/J

[Anonymous]

Hi tex68

Thanks for the quick replay

i am attaching the screenshot for your refrence. In that need to find the Open measures and requriment is mentioned in the note feild.

Thanks!!

Nagaraju.G 

[mahoneypat · Accepted solution]

Assuming you have your first 3 columns in your data, here is an expression that will work

Open =
VAR __thisdate =
MAX ( Table[Date] )
RETURN
CALCULATE (
SUMX ( Table, Table[Opened] - Table[Closed] ),
ALL ( Table ),
Table[Date] <= __thisdate
)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat