Combo Chart not Calculating Percentages based on X axis

[airetamstorm]

The solution I found is not returning the intended value.  I need the stacked columns shown in the top / left graph with an added line as shown in the other graphs. 

When I update the chart type to a combo it takes %s' as a whole as opposed to each month equaling 100%

The solution on the bottom right gets closer but the formula is using SUM for the ID field when it needs to use count, (each unique value = 1) doing this causes an error. Charts, data and measure can be found below. 

[Anonymous · Accepted solution]

Hi @airetamstorm ,

I think you just need to use count for the ID field in your formula.

MEASURE = 
VAR _count1 =
    CALCULATE (
        COUNT ( 'Table'[ID] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Date].[Month] = MAX ( 'Table'[Date].[Month] )
                && 'Table'[Type] = MAX ( 'Table'[Type] )
        )
    )
VAR _count2 =
    CALCULATE (
        COUNT ( 'Table'[ID] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Date].[Month] = MAX ( 'Table'[Date].[Month] )
        )
    )
RETURN
    DIVIDE ( _count1, _count2 )

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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