Getting percentage count by days

Hi dollaratneu ,

Based on your description, you can create a new calculated table like this:

New Table = 
VAR t1 =
    ADDCOLUMNS (
        'Table',
        "Month Days",
            SWITCH (
                TRUE (),
                'Table'[date].[MonthNo] = 1
                    && 'Table'[date].[Day] >= 1
                    && 'Table'[date].[Day] < 20, "Jan-20 <2",
                'Table'[date].[MonthNo] = 1
                    && 'Table'[date].[Day] >= 20
                    && 'Table'[date].[Day] <= 31, "Jan-20 >2",
                'Table'[date].[MonthNo] = 2
                    && 'Table'[date].[Day] >= 1
                    && 'Table'[date].[Day] < 20, "Feb-20 <2",
                'Table'[date].[MonthNo] = 2
                    && 'Table'[date].[Day] >= 20
                    && 'Table'[date].[Day] <= 29, "Feb-20 >2"
            ),
        "Total Count",
            CALCULATE (
                COUNT ( 'Table'[date] ),
                ALLEXCEPT ( 'Table', 'Table'[date].[MonthNo] )
            )
    )
VAR t2 =
    ADDCOLUMNS (
        t1,
        "Count",
            SWITCH (
                TRUE (),
                [days] < 2
                    && [Month Days] = "Jan-20 <2",
                    COUNTX ( FILTER ( t1, [days] < 2 && [Month Days] = "Jan-20 <2" ), [date] ),
                [days] >= 2
                    && [Month Days] = "Jan-20 >2",
                    COUNTX ( FILTER ( t1, [days] >= 2 && [Month Days] = "Jan-20 >2" ), [date] ),
                [days] < 2
                    && [Month Days] = "Feb-20 <2",
                    COUNTX ( FILTER ( t1, [days] < 2 && [Month Days] = "Feb-20 <2" ), [date] ),
                [days] >= 2
                    && [Month Days] = "Feb-20 >2",
                    COUNTX ( FILTER ( t1, [days] >= 2 && [Month Days] = "Feb-20 >2" ), [date] )
            )
    )
RETURN
    SUMMARIZE (
        SUMMARIZE (
            FILTER ( t2, [Count] <> BLANK () ),
            [Month Days],
            [Total Count],
            [Count],
            "%", [Count] / [Total Count]
        ),
        [Month Days],
        [%]
    )

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.