Sorting and calculating Cumulative value

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

WINDOW function (DAX) - DAX | Microsoft Learn

Expected result measure: =
CALCULATE (
    SUM ( Data[Column B] ),
    FILTER (
        Data,
        DIVIDE (
            CALCULATE (
                SUM ( Data[Column B] ),
                WINDOW (
                    1,
                    ABS,
                    0,
                    REL,
                    SUMMARIZE ( ALL ( Data ), Category[Column A], Data[Column B] ),
                    ORDERBY ( CALCULATE ( SUM ( Data[Column B] ) ), DESC ),
                    DEFAULT,
                    PARTITIONBY ( Category[Column A] )
                )
            ),
            CALCULATE (
                SUM ( Data[Column B] ),
                WINDOW (
                    1,
                    ABS,
                    -1,
                    ABS,
                    SUMMARIZE ( ALL ( Data ), Category[Column A], Data[Column B] ),
                    ORDERBY ( CALCULATE ( SUM ( Data[Column B] ) ), DESC ),
                    DEFAULT,
                    PARTITIONBY ( Category[Column A] )
                )
            )
        ) <= 0.7
    )
)

Jihwan_Kim  Thanks, will test out ...its surely getting closure

Hello Jihwan_Kim 

Attached is my sample data ... I want to sort first based on Q column, then based on Cell2 colum

n and then pages in descending order. As in excel scrennshot below

Then calculate cumulative % for Pages based on above sorting for each category. Kindly refer below.