Forum Discussion

Sirhawk3017's avatar
Sirhawk3017
Icon for Helper II rankHelper II
1 year ago
Solved

Power BI: Need Help Creating Quarterly Rank and Quartiles

I need help creating quartiles in Power BI based on a quarterly rank, but I don't have the ranking measure yet. I want to: Create a measure that ranks my sales data each quarter Divide my data int...
General Comment
Need Help
Tutorial Requests
  • Sirhawk3017's avatar
    Sirhawk3017
    1 year ago

    tried this formula and seemed to work; 

     

    Quartile =
    VAR RankedTable =
        ADDCOLUMNS(
            ALL(Medic_Info),
            "Rank", [FM Sales QTD Rank]  // Add a temporary rank column
        )
    VAR MaxRank = MAXX(RankedTable, [Rank])  // Get the max rank from the temporary table
    VAR QuartileSize = CEILING(MaxRank / 4, 1)
    RETURN
        SWITCH(
            TRUE(),
            [FM Sales QTD Rank] <= QuartileSize, 1,
            [FM Sales QTD Rank] <= QuartileSize * 2, 2,
            [FM Sales QTD Rank] <= QuartileSize * 3, 3,
            4
        )
Sirhawk3017's avatar
Sirhawk3017
Icon for Helper II rankHelper II
1 year ago

tried this formula and seemed to work; 

 

Quartile =
VAR RankedTable =
    ADDCOLUMNS(
        ALL(Medic_Info),
        "Rank", [FM Sales QTD Rank]  // Add a temporary rank column
    )
VAR MaxRank = MAXX(RankedTable, [Rank])  // Get the max rank from the temporary table
VAR QuartileSize = CEILING(MaxRank / 4, 1)
RETURN
    SWITCH(
        TRUE(),
        [FM Sales QTD Rank] <= QuartileSize, 1,
        [FM Sales QTD Rank] <= QuartileSize * 2, 2,
        [FM Sales QTD Rank] <= QuartileSize * 3, 3,
        4
    )