Get a % from two separate matrix tables

[KGards7]

I have two matrix tables both drawing information from the same imported excel document.

The first table is Requests that have come into our queue and uses:

. Columns: "Date of Request Creation" 

. Values: "Count of Requests"

The second table is exactly the same but uses a column called Date of Request Closure:

. Columns: "Date of Request Closure"

. Values: "Count of Requests"

I need to find a way for the second table to be a percent of the first so if the first table says that 50 requests were created on a particular day and the second table says that 25 requests were closed on that same day I want the second table to say 50%, not 25.

Can anyone help?

[Anonymous · Accepted solution]

Hi @KGards7 ,

Here I create a sample to have a test.

Measure:

Percentage = 
VAR _COUNT_START =
    CALCULATE (
        COUNT ( 'Table'[Requests] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Date of Request Creation] = MAX ( 'Table'[Date of Request Closure] )
        )
    )
VAR _COUNT_CLOSURE =
    CALCULATE ( COUNT ( 'Table'[Date of Request Closure] ) )
RETURN
    DIVIDE ( _COUNT_CLOSURE, _COUNT_START )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.