Need a DAX function to show percentage counts in current Qtr over counts in previous Qtr

[E12345]

Hi!

I am relatively new to DAX, and I really need some help and hope to get some answers/ideas from the PBI Community. 
I need a DAX function that would help me calculate (as percentage) a number of Closed Tickets in "Current Qtr" over Total Number of Open Tickets in Prior Qtr. I will provide a dummy sample data in Excel, if needed. 

Here is a snapshot of my Excel Data (I will attach a PBIX with it): 

In the above snapshot, the column that defines a separate quarter is shown as "Quarter End Date"
For Example, Quarter that ends in 3/1/2023 has 3 tickets with Status "Closed"
The previous Quarter, Qtr that ends on 12/31/2022, has 6 tickets with Status "Open"
So, for Qtr 3/1/2023 I need to calculate Closed over Open Percentage, which is 3 / 6 * 100 = 50 %
I need those numbers calculated for every Qtr
(distinct count of closed tickets over distinct count of open tickets in perviosu quarter) 
So, what I need is somethign like that as a line chart, with each Quarter as the X-axis and the Percentage as Y Axis:

Can you please provide a dax for this particular visual? Please note that I cannot create my own columns, so I have to deal with whatever columns I have. 

I have a PBIX sample with data, but I can't seem to find how to attachi it... Sorry. 

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[E12345]

I don't see how to share my PBIX here - there s no icon to download....

Somehow the other helper who offered a solution shared his PBIX - it is perfect for my needs, except I must have a DAX to calculate the distinct count of tickets (not just the count). Is there a way have a dax that would work with the distinct count of closed tickets over distinct count of open tickets? 

[Ashish_Mathur]

You may upload the file to Google Drive and share the download link here.

[ryan_mayu · Accepted solution]

@E12345 

you can try to create a measure

Measure = 
VAR _open=countx(FILTER(all('Table'),'Table'[date]=EOMONTH(max('Table'[date]),-3)&&'Table'[status]="Open"),'Table'[ticket no])
return if(ISBLANK(_open),BLANK(),countx(FILTER('Table','Table'[status]="Closed"),'Table'[ticket no])/_open)

pls see the attachment below

[E12345]

Hi, 

Wow, thank you for the prompt response! Your solution did work (so excited!!), but I realized that my actual data needs to have a "distinct count" of tickets instead of just count (you use COUNTX to get the count). Is there a way to revamp your formula to pick up distinct count of closed tickets over distinct count of open tickets (so, if some tickets have the same number, they ought to be counted as one ticket)? THANKS!!!

UPDATE: I was able to modify your function to work for distinct counts (hip hip hurray!).
For some reason I cannot figure out hot to upload the PBIX with the new finction (if anyone could direct me, that would be great!). The new Dax works perfectly with distinct counts and I tested it out with my real data as well. 
Will paste it here if anyone neeeds it (I set the format to Percent (%) to show that values as percentages)

Measure Distinct Counts =

VAR _Open =

calculate(

DISTINCTCOUNT('Table'[ticket no]),

FILTER (

ALLSELECTED ( 'Table' ),

'Table'[status]="Open"

&& 'Table'[date] = EOMONTH (MAX ( 'Table'[date]), -3)

)

)

VAR _closed =

calculate(

DISTINCTCOUNT('Table'[ticket no]),

FILTER (

ALLSELECTED ( 'Table' ),

'Table'[status]="Closed"

&& 'Table'[date] = EOMONTH (MAX ('Table'[date]), 0)

)

)

Return

if(ISBLANK(_closed),0, Divide(_closed, _open))

THANK YOU AGAIN! 

[ryan_mayu]

you are welcome