% of filtered columns

[AmberJane]

For this report I have a filter to show me just closed tickets and I want to do a % of the types of closure reasons from the total number of the closed tickets. So I would expect to see 83% resolved, 16% Declined and 1% Declined - Too Old to Fix. Keeping in mind that we may add more closure reasons down the line. 

[AmberJane]

In my current report I added the measure: 

Closure Reason % =

VAR sum_ =

CALCULATE (

SUM ( 'PM Tickets'[Linked Ticket ID] ),

FILTER ( ALL ( 'PM Tickets' ), 'PM Tickets'[Linked State] = SELECTEDVALUE ( 'PM Tickets'[Linked State] ) )

)

VAR count_ =

CALCULATE ( SUM ( 'PM Tickets'[Linked State] ), ALLEXCEPT ( 'PM Tickets', 'PM Tickets'[Closure Reason]) )

RETURN

count_ / sum_

Before adding the new measure to the report it looks like this:

After adding the new column to the report I receive this error: 

I created test data which I will attach. In this case the measure does work without erroring but the %'s are wrong. 

[v-henryk-mstf]

Hi @AmberJane ,

According to your description, I did a test reference as follows:

M_count =
VAR sum_ =
    CALCULATE (
        SUM ( 'Table'[Col] ),
        FILTER ( ALL ( 'Table' ), 'Table'[State] = SELECTEDVALUE ( 'Table'[State] ) )
    )
VAR count_ =
    CALCULATE ( SUM ( 'Table'[Col] ), ALLEXCEPT ( 'Table', 'Table'[Reason] ) )
RETURN
    count_ / sum_

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

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

[AmberJane]

I am getting an error that .pbix is not supported when attempting to attach the test data.